Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
) <> EXTRACT (
) OVER
AS ( SELECT
AT TIME ZONE
BETWEEN -8 AND -5
BY c.time_zone
c.country = 'US'
c.time_zone ) FROM
cities c WHERE
cities JOIN
CREATE
INTO cities
LAG
LIKE 'US/%'
ON ( time_zone )
SELECT EXTRACT (
SELECT TZ_OFFSET
SET c.time_zone =
TABLE cities (
time_zone VARCHAR2
TIMEZONE_HOUR
TO_TIMESTAMP
USING
WITH TIME ZONE,

Legend

= choice is in the correct position in the solution.
= choice is in the solution but was in the incorrect position.
= choice is not in the solution.