GROUP BY
Beginner
Count Employees Per Department
Count the number of employees in each department. Return columns: department_id, employee_count. Order results by: department_id.
10 XPSolve challenge
Interactive SQL practice
GROUP BY Exercises
Build grouped reports with COUNT, SUM, AVG, GROUP BY and HAVING. These 38 interactive challenges use real schemas and instant query validation.
Practice this concept
Start with a free exercise
Count Employees Per DepartmentMore exercises on this topic38 SQL challenges
Open Practice ArenaGROUP BY
Beginner
Customers per Country
Count customers in each country, sorted by the country name. Return columns: country, customer_count. Order results by: country.
10 XPSolve challenge
HAVING
Intermediate
Departments with High Average Salary
Find departments where the average salary is greater than 75,000. Return columns: department_id, avg_salary. Order results by: department_id.
25 XPSolve challenge
GROUP BY
Intermediate
Order Status Summary
Show the order count and total amount for each status. Return columns: status, order_count, total_amount. Order results by: status.
25 XPSolve challenge
HAVING
Intermediate
Repeat Customers
Find customers who placed more than one order. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
25 XPSolve challenge
HAVING
Advanced
Customers With At Least 1 Orders
Return customers who placed at least 1 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
Customers With At Least 2 Orders
Return customers who placed at least 2 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers With At Least 3 Orders
Return customers who placed at least 3 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers With At Least 4 Orders
Return customers who placed at least 4 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers With At Least 5 Orders
Return customers who placed at least 5 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers With At Least 6 Orders
Return customers who placed at least 6 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers With At Least 7 Orders
Return customers who placed at least 7 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers With At Least 8 Orders
Return customers who placed at least 8 orders. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
Customers Spending Above 250
Find customers whose total completed-order spend exceeds 250. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
Customers Spending Above 500
Find customers whose total completed-order spend exceeds 500. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers Spending Above 750
Find customers whose total completed-order spend exceeds 750. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers Spending Above 900
Find customers whose total completed-order spend exceeds 900. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers Spending Above 1200
Find customers whose total completed-order spend exceeds 1200. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers Spending Above 1500
Find customers whose total completed-order spend exceeds 1500. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers Spending Above 1800
Find customers whose total completed-order spend exceeds 1800. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
PRO
Customers Spending Above 2500
Find customers whose total completed-order spend exceeds 2500. Return columns: customer_name, total_spend. Order results by: total_spend DESC, customer_name.
50 XPSolve challenge
HAVING
Advanced
Order Status Revenue Above 250
Summarize order statuses whose total revenue is above 250. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
Order Status Revenue Above 500
Summarize order statuses whose total revenue is above 500. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
PRO
Order Status Revenue Above 750
Summarize order statuses whose total revenue is above 750. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
PRO
Order Status Revenue Above 900
Summarize order statuses whose total revenue is above 900. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
PRO
Order Status Revenue Above 1200
Summarize order statuses whose total revenue is above 1200. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
PRO
Order Status Revenue Above 1500
Summarize order statuses whose total revenue is above 1500. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
PRO
Order Status Revenue Above 1800
Summarize order statuses whose total revenue is above 1800. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Advanced
PRO
Order Status Revenue Above 2500
Summarize order statuses whose total revenue is above 2500. Return columns: status, order_count, total_revenue. Order results by: total_revenue DESC, status.
50 XPSolve challenge
HAVING
Expert
PRO
Customers Buying Both Categories
Find customers who purchased products from both Software and Infrastructure. Return columns: customer_name, category_count. Order results by: c.name.
100 XPSolve challenge
HAVING
Expert
Products With Revenue Above 250
Find products whose order-item revenue exceeds 250. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
Products With Revenue Above 500
Find products whose order-item revenue exceeds 500. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
PRO
Products With Revenue Above 750
Find products whose order-item revenue exceeds 750. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
PRO
Products With Revenue Above 900
Find products whose order-item revenue exceeds 900. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
PRO
Products With Revenue Above 1200
Find products whose order-item revenue exceeds 1200. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
PRO
Products With Revenue Above 1500
Find products whose order-item revenue exceeds 1500. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
PRO
Products With Revenue Above 1800
Find products whose order-item revenue exceeds 1800. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
HAVING
Expert
PRO
Products With Revenue Above 2500
Find products whose order-item revenue exceeds 2500. Return columns: product_name, units_sold, revenue. Order results by: revenue DESC, product_name.
100 XPSolve challenge
Concept guide
How to practice GROUP BY
GROUP BY turns detailed rows into grouped summaries. It is commonly paired with COUNT, SUM, AVG, MIN, MAX and HAVING for reporting questions.
What to master
- • Group by every selected non-aggregate expression
- • Use WHERE before grouping and HAVING after grouping
- • Check how NULL values form groups
- • Order summaries explicitly when ranking groups
A reliable problem-solving workflow
- 1Decide the grain of one output row.
- 2Select the grouping columns.
- 3Add the required aggregate functions.
- 4Apply row filters with WHERE and aggregate filters with HAVING.
What is the difference between WHERE and HAVING?
WHERE filters source rows before grouping. HAVING filters the grouped results after aggregate functions are calculated.
Can GROUP BY be used without an aggregate function?
Yes, but it usually behaves like a distinct list of grouping values. DISTINCT is often clearer when no aggregation is required.