CREATE TABLE people (country VARCHAR)

Show all countries and the number of people from each country.
SELECT country, COUNT(*) FROM people GROUP BY country
SELECT "country", COUNT(*) FROM "people" GROUP BY "country"