Project 19: Users by Country Count
SQL Architect
Builds on these lessons
Query Task
Objective
GROUP BY collapses rows sharing the same value in a column into one summary row each — almost always paired with an aggregate function like COUNT to say something about each group.
You're given a users table with columns id, name, and country.
Task: write a query returning country and a count of users, one row per country.
query.sql
SELECT country, COUNT(*) FROM users GROUP BY country;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results