CREATE TABLE pilot (Pilot_name VARCHAR, Rank VARCHAR)

List the names of pilots in ascending order of rank.
SELECT Pilot_name FROM pilot ORDER BY Rank
SELECT "Pilot_name" FROM "pilot" ORDER BY "Rank" NULLS FIRST