CREATE TABLE event (name VARCHAR2, id VARCHAR2, stadium_id VARCHAR2)
CREATE TABLE stadium (name VARCHAR2, id VARCHAR2, stadium_id VARCHAR2)

Find the names of stadiums which have never had any event.
SELECT name FROM stadium WHERE NOT id IN (SELECT stadium_id FROM event)
SELECT "name" FROM "stadium" WHERE NOT "id" IN (SELECT "stadium_id" FROM "event")