What are the different nationalities of pilots? Show each nationality and the number of pilots of each nationality.
create table pilot (nationality varchar, PRIMARY KEY (nationality))
select nationality, count(*) from pilot group by nationality