CREATE TABLE pilot_record (Pilot_name VARCHAR2, Pilot_ID VARCHAR2)
CREATE TABLE pilot (Pilot_name VARCHAR2, Pilot_ID VARCHAR2)

List the names of pilots that do not have any record.
SELECT Pilot_name FROM pilot WHERE NOT Pilot_ID IN (SELECT Pilot_ID FROM pilot_record)
SELECT "Pilot_name" FROM "pilot" WHERE NOT "Pilot_ID" IN (SELECT "Pilot_ID" FROM "pilot_record")