Show the pilot names and their nationalities.
select pilot_name, nationality from pilot
Which nationalities have the pilots whose position is "Center Team"?
select nationality from pilot where position = "Center Team"
Show the nationalities and the number of pilots for each.
select nationality, count(*) from pilot group by nationality