Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
Complete this ↑ using these ↓ Press to guess ↑
'New York Knick%s'
( home_team,
( PARTITION BY
(*) OVER
) KEEP (
) WITHIN GROUP
, LISTAGG ( score
AND away_team LIKE
BETWEEN
BY ALL ORDER
COLLATE
DENSE_RANK ()
DESC NULLS FIRST
FETCH FIRST
game_date ) FROM
games WHERE
home_team =
IS NOT
JOIN TO ONE (
OFFSET
PRECEDING
SELECT MIN (
teams,
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.