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
### Context: CREATE TABLE pilot (Pilot_name VARCHAR, Rank VARCHAR) ### Question: List the names of pilots in ascending order of rank. ### Answer: SELECT Pilot_name FROM pilot ORDER BY Rank