Schema: CREATE TABLE pilot (Join_Year VARCHAR, Rank VARCHAR)
Question: What is the joined year of the pilot of the highest rank?
SQL: SELECT Join_Year FROM pilot ORDER BY Rank LIMIT 1