Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
( PARTITION
, max_speed FROM
= CASE WHEN
ASC,
BETWEEN 500
BY max_speed DESC
END AS
FETCH FIRST
FIRST_VALUE
GROUP BY max_speed
INNER JOIN
MATCH_RECOGNIZE (
NULLS LAST
OVER ( ORDER BY
ROW ONLY
SELECT MAX ( speed
SELECT t.*
SELECT train_name
SKIP
TIES
trains ORDER
WHERE train_name
WINDOW
WITH fastest_train

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.