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