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 ↑
) pct FROM
, votes, seat
= NVL (
BY seat, pct DESC
candidates c ORDER
candidates QUALIFY
CURRENT ROW AND
FIRST ROW
FOLLOWING )
GROUP BY seat
GROUPS BETWEEN
HAVING MAX
INTO candidates
JOIN seats s ON
LAST
NOT LIKE
OVER
RATIO_TO_REPORT (
SELECT c.*,
SET winner =
USING (
votes ) OVER (
WINDOW
WITH results AS

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.