Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
'YYYY' )
( MONTH FROM
) = 4
4 ROWS ONLY
accession_date )
BY yr FETCH
BY yr HAVING
COUNT (*) = 4
DATE
GROUP BY yr HAVING
IGNORE NULLS
JOIN
LAST_DAY
ON accession_date
ORDER BY yr
OVER
PARTITION
SELECT COUNT
SELECT EXTRACT (
SUM (
TO_CHAR
USING (
YEAR FROM
yr FROM

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.