Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
(*) = 0
) AND p.id
) OVER
, LATERAL
<> h.pitch_id OR
BY ALL
COUNT ( h.pitch_id
CROSS APPLY (
FROM pitches WHERE
h WHERE p.id =
h.pitch_id )
INTO
LEFT JOIN hits
NOT EXISTS (
NOT IN
NOT NULL
p.*, h.*,
p.pitcher FROM
pitch_id HAVING
pitches p WHERE
SELECT 'no hits'
SELECT 0 FROM hits
WHERE NOT
WITH no_hitter

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.