SELECT Pilot_name FROM pilot WHERE Pilot_ID NOT IN (SELECT Pilot_ID FROM pilot_record)
List the names of pilots that do not have any record.
SELECT Pilot_name FROM pilot WHERE Pilot_ID NOT IN ( SELECT Pilot_ID FROM pilot_record )
select pilot_name from pilot where pilot_id not in ( select pilot_id from pilot_record )
List the names of pilots that do not have any record .