CREATE TABLE pilot (pilot_id DECIMAL, pilot_name TEXT, rank DECIMAL, age DECIMAL, nationality TEXT, position TEXT, join_year DECIMAL, team TEXT)
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)

What is the joined year of the pilot of the highest rank?
SELECT join_year FROM pilot ORDER BY rank LIMIT 1
SELECT "join_year" FROM "pilot" ORDER BY "rank" NULLS FIRST LIMIT 1