HAVING Filtering Groups
Intermediate
Marketing wants repeat customers only: users who placed more than one order.
Write a query returning user_id and order_count for the users that have more than 1 order, using GROUP BY and HAVING.
Constraints
- Columns, in order:
user_id,order_count - Only groups whose count is greater than 1
Hints
Hint 1
WHERE cannot see aggregate results; HAVING can.
Hint 2
HAVING COUNT(*) > 1 goes right after GROUP BY.
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.