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 ↑
) = 1
) OVER ( PARTITION
, FIRST_VALUE
[ cv() ]
AS temp_f >= 100 )
CURRENT ROW
DIMENSION
FOLLOWING )
GROUPS BETWEEN
HAVING MAX (
JOIN places
MATCH_RECOGNIZE (
MEASURES COUNT
MODEL
ORDER BY temp_on
PARTITION BY place
PATTERN ( hot
QUALIFY RANK
ROW_NUMBER () OVER
RULES
temp_on ASC NULLS
WHERE temp_f >=
WINDOW hot AS
{160} ) DEFINE hot

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.