Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
) =
, 2 ) OVER
, COUNT (*)
< SYSDATE
asteroid_name FROM
asteroids GROUP
asteroids JOIN
asteroids ORDER
asteroids WHERE
BY
FIRST 1 ROW ONLY
FIRST_VALUE (
FULL OUTER
HAVING
MATCH_RECOGNIZE
NTH_VALUE
OFFSET 1 ROW FETCH
ON id =
ROW FETCH FIRST
ROWS BETWEEN
SELECT
SELECT *
WINDOW
WITH TIES

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.