List the names of pilots in ascending order of rank.
CREATE TABLE pilot (Pilot_name VARCHAR, Rank VARCHAR)
SELECT Pilot_name FROM pilot ORDER BY Rank
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE pilot (Pilot_name VARCHAR, Rank VARCHAR) Question: List the names of pilots in ascending order of rank. [/INST] SELECT Pilot_name FROM pilot ORDER BY Rank </s>