GROUP BY Aggregation
Intermediate
The dashboard shows order volume per customer instead of individual orders.
Write a query returning each user_id from orders together with the number of orders that user placed, named order_count.
Constraints
- Columns, in order:
user_id,order_count - One row per distinct
user_id - Row order does not matter
Hints
Hint 1
GROUP BY forms one group per distinct value of a column.
Hint 2
Aggregate functions like COUNT(*) are computed once per group.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.