SELECT name FROM stadium WHERE id NOT IN (SELECT stadium_id FROM event)
Find the names of stadiums which have never had any event.
SELECT name FROM stadium WHERE id NOT IN ( SELECT stadium_id FROM event )
select name from stadium where id not in ( select stadium_id from event )
Find the names of stadiums which have never had any event .