Filtering & predicates
Exercise · SQL & Querying

Predict, then run it

Predict the output

guests(id) = 1,2,3; episodes(guest_id) = 1, NULL. Which guests never appeared:

SELECT id FROM guests WHERE id NOT IN (SELECT guest_id FROM episodes);

Predict the exact output.