Hello, how many different nationalities of pilots are there?
select count ( distinct nationality ) from pilot
What are the pilot names of those 3 nationalities?
select nationality,pilot_name from pilot
What is the most common nationality of the 3 nationalities?
select nationality from pilot group by nationality order by count ( * ) desc limit 1