SELECT Nationality ,  COUNT(*) FROM pilot GROUP BY Nationality
What are the different nationalities of pilots? Show each nationality and the number of pilots of each nationality.
SELECT Nationality , COUNT ( * ) FROM pilot GROUP BY Nationality
select nationality , count ( * ) from pilot group by nationality
What are the different nationalities of pilots ? Show each nationality and the number of pilots of each nationality .