Schema: CREATE TABLE member (Country VARCHAR)
Question: Show the different countries and the number of members from each.
SQL: SELECT Country, COUNT(*) FROM member GROUP BY Country