Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
'old' ORDER
(*) )
) WITHIN GROUP
= s.sea_id WHERE
ALL ROWS
END =
FIRST ROW
FOR m.age IN
LISTAGG
m.age = 'old'
m.sea_id
man INNER JOIN
man m JOIN sea s
MATCH_RECOGNIZE
MEASURES
OVER ( PARTITION
PATTERN (
s.sea_name FROM
sea_id QUALIFY
SELECT m.age ||
UNPIVOT (
USING ( sea_id )
WHEN m.age
WINDOW

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.