SELECT Pilot_name FROM pilot ORDER BY Rank ASC
List the names of pilots in ascending order of rank.
SELECT Pilot_name FROM pilot ORDER BY Rank ASC
select pilot_name from pilot order by rank asc
List the names of pilots in ascending order of rank .