Table 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