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 ↑
( PARTITION
( photo ) OVER (
) FROM
) OVER (
BETWEEN moon AND
BY taken_on NULLS
COUNT (*) FOR (
CREATE TABLE
GROUP BY
INDEX taken_i ON
JOIN subjects ON
LAST_VALUE (
OFFSET 0 FETCH
ORDER BY
photos WHERE
QUALIFY RANK ()
SELECT FIRST_VALUE
SELECT p.*,
subject = 'earth'
TIES
UNPIVOT
WHERE subject LIKE
WINDOW earth AS
WITH earthrise 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.