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 ↑
'Heidelberg' AS
'Heidelberg' ORDER
= '09:00' AND
BY starts FETCH
BY starts NULLS
CEIL ( starts ),
CREATE VIEW
DATE
EXTRACT ( HOUR
FETCH FIRST ROW
FIRST 1 ROW ONLY
GROUP BY
INTERVAL '1' HOUR
JOIN universities
lecture_times AS (
ROWS BETWEEN
SELECT l.*,
SELECT TO_CHAR (
starts, 'hh24:mi'
TIES
TO_TIMESTAMP (
university LIKE
WHERE university =
WITH lecture_times

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.