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.
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.