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