SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality
How many people are there of each nationality?
SELECT Nationality , COUNT ( * ) FROM people GROUP BY Nationality
select nationality , count ( * ) from people group by nationality
How many people are there of each nationality ?