Table schema:
CREATE TABLE people (Nationality VARCHAR)

Question: What are different nationalities of people and the corresponding number of people from each nation?
SQL: SELECT Nationality, COUNT(*) FROM people GROUP BY Nationality