Select the countries users are from and count users from each country.
Make sure to pick SELECT followed by country, and then COUNT(*) AS users, GROUP BY country.
SELECT
country,
COUNT(*) AS users
GROUP BY country