Count Users By Country

Given a table Users that looks like this:

The query to COUNT the number of users by country is:

SELECT country, COUNT(country) FROM users
GROUP BY country

The query uses the GROUP BY clause to group the users by country and then shows the count in the next column. The result of the query looks like this: