Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
'Huaynaputina'
( PARTITION
( volcano, vei )
) OVER
* FROM
, vei DESC FETCH
1 FOLLOWING
1 ROW ONLY
BY continent
erupted_on FROM
FIRST 9 continent,
GROUP BY continent
GROUPS BETWEEN
JOIN volcanoes
NULLS
ORDER BY continent
OUTER
ROLLUP ( continent
SELECT MAX (
SELECT volcano,
WHERE
WINDOW duration
WITH
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.