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