SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality
What are different nationalities of people and the corresponding number of people from each nation?
SELECT Nationality , COUNT ( * ) FROM people GROUP BY Nationality
select nationality , count ( * ) from people group by nationality
What are different nationalities of people and the corresponding number of people from each nation ?