Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
( h{4} ) DEFINE h
( PARTITION BY
) OVER (
100 FOLLOWING
= 4
= MAX
ALL ROWS PER
AS score >= 100 )
BY player ORDER
COUNT (*) OVER
DEFINE
FIRST_VALUE (
HAVING COUNT
innings_dt PATTERN
INTO runs
NULLS
ORDER
PATTERN
player ORDER BY
player, score
ROWS UNBOUNDED
SELECT
SELECT * FROM runs
UPDATE runs

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.