Table schema:
CREATE TABLE players (country_code VARCHAR)

Question: find the number of players for each country.
SQL: SELECT COUNT(*), country_code FROM players GROUP BY country_code