What is the joined year of the pilot of the highest rank?
SELECT Join_Year FROM pilot ORDER BY Rank ASC LIMIT 1
joined year refers to Join_Year; pilot of the highest rank refers to MIN(Rank) because rank is ordered in ascending order where the highest rank is the smallest numerical value;