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 ↑
( i crash ) DEFINE
( value ) RULES
) DEFINE crash AS
, CLASSIFIER
< FIRST
ALL ROWS PER MATCH
BY value_date
COUNT (*) AS
COUNT (*) FOR
DIMENSION BY
FINAL
MATCH_NUMBER () AS
MATCH_RECOGNIZE (
MEASURES
MODEL
ONE ROW
PATTERN ( i crash
RUNNING
SEQUENTIAL ORDER
SKIP TO
UNPIVOT
value ) * 0.5 )
value < PREV (
value [ CV() ]

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.