Database: wedding
Question: Show all countries and the number of people from each country.
SQL:
SELECT country ,  count(*) FROM people GROUP BY country