SCHEMA:
CREATE TABLE pilot (Pilot_name VARCHAR, Rank VARCHAR)
USER:
List the names of pilots in ascending order of rank.

QUERY:
SELECT Pilot_name FROM pilot ORDER BY Rank