Show all the pilot names
select pilot_name from pilot
How many in total?
select count(pilot_name) from pilot
Order them in ascending order of the rank.
select pilot_name from pilot order by rank asc