Schema: CREATE TABLE singer (country VARCHAR)
Question: Show all countries and the number of singers in each country.
SQL: SELECT country, COUNT(*) FROM singer GROUP BY country