Show the pilot names and their nationalities.
select pilot_name, nationality from pilot
Which nationalities have the pilots who is younger than 34?
select nationality from pilot where age < 34
Show each one and the number of pilots.
select nationality, count(*) from pilot group by nationality
Among those, which one is the most popular one?
select nationality from pilot group by nationality order by count(*) desc limit 1