Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
( team_id )
+ away_goals
, away_team, ABS (
31 AND 0
ASC,
away_goals ) diff
away_team LIKE
BY diff DESC FETCH
CASE WHEN
FIRST 1 ROW
FIRST ROW ONLY
FROM games GROUP
FROM games ORDER
IN ( 31, 0 )
IS NOT NULL
JOIN teams
NULLS
ON home_team =
OVER ( ORDER
SELECT home_team
SIGN
VIEW
WINDOW
WITH score_diffs

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.