CREATE TABLE aircraft (aircraft_id DECIMAL, order_year DECIMAL, manufacturer TEXT, model TEXT, fleet_series TEXT, powertrain TEXT, fuel_propulsion TEXT)
CREATE TABLE pilot_record (record_id DECIMAL, pilot_id DECIMAL, aircraft_id DECIMAL, date TEXT)
CREATE TABLE pilot (pilot_id DECIMAL, pilot_name TEXT, rank DECIMAL, age DECIMAL, nationality TEXT, position TEXT, join_year DECIMAL, team TEXT)

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")