Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
( DENSE_RANK
( home_team ) KEEP
( PARTITION
) KEEP (
, COUNT (*),
, ROW_NUMBER
AND MIN
AS
away_team,
BY away_team,
DENSE_RANK ()
DISTINCT
FETCH FIRST
FIRST ORDER BY
FROM test_matches
GROUPS BETWEEN
HAVING MAX (
MIN ( COUNT (*) )
QUALIFY
SELECT MIN (
start_date ), MIN
test_matches GROUP
UNBOUNDED
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.