What is the joined year of the pilot of the highest rank?
CREATE TABLE pilot (Join_Year VARCHAR, Rank VARCHAR)
SELECT TOP 1 Join_Year FROM pilot ORDER BY Rank
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE pilot (Join_Year VARCHAR, Rank VARCHAR) Question: What is the joined year of the pilot of the highest rank? [/INST] SELECT TOP 1 Join_Year FROM pilot ORDER BY Rank </s>