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
[{'Country': 'Australia', 'count(*)': 1}, {'Country': 'Canada', 'count(*)': 1}, {'Country': 'Northern Ireland', 'count(*)': 1}, {'Country': 'Sweden', 'count(*)': 1}, {'Country': 'United States', 'count(*)': 8}]