Database: pilot_record
Question: List the names of pilots in ascending order of rank.
SQL:
SELECT Pilot_name FROM pilot ORDER BY Rank ASC