Show all the pilot names and the join years.
select pilot_name, join_year from pilot
How many unique years are there?
select count(join_year) from pilot
List the years by the pilot rank in ascending order.
select join_year from pilot order by rank asc
In which join year, the pilot has the highest rank?
select join_year from pilot order by rank asc limit 1