CREATE TABLE affected_region (name VARCHAR2, storm_id VARCHAR2)
CREATE TABLE storm (name VARCHAR2, storm_id VARCHAR2)

Show the name of storms which don't have affected region in record.
SELECT name FROM storm WHERE NOT storm_id IN (SELECT storm_id FROM affected_region)
SELECT "name" FROM "storm" WHERE NOT "storm_id" IN (SELECT "storm_id" FROM "affected_region")