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