Schema: CREATE TABLE people (country VARCHAR)
Question: Show all countries and the number of people from each country.
SQL: SELECT country, COUNT(*) FROM people GROUP BY country