What are different nationalities of people and the corresponding number of people from each nation?
CREATE TABLE people (Nationality VARCHAR)
SELECT Nationality, COUNT(*) FROM people GROUP BY Nationality
### Context: CREATE TABLE people (Nationality VARCHAR) ### Question: What are different nationalities of people and the corresponding number of people from each nation? ### Answer: SELECT Nationality, COUNT(*) FROM people GROUP BY Nationality