Back to Practice
#0190
Users With Repeat Purchases
MediumSQL25 min20 XP
Problem
Return user_id values for users with at least two purchases.
Why This Matters
HAVING is essential when the filter depends on an aggregate like COUNT, SUM, or AVG.
Schema
purchases(user_id INTEGER, purchase_id INTEGER)
Examples
Example 1
Inputuser 1 has two purchases; user 2 has one
Outputuser 1
Only user 1 reaches count >= 2.
Constraints
- Return the exact requested result.
- Handle common edge cases.
- Keep the solution readable before optimizing.
CodeSQL
Visible browser tests run here when available.
Testcases1 visible / 3 hidden categories
Core example
Inputuser 1 has two purchases; user 2 has one
Expecteduser 1
Only user 1 reaches count >= 2.
Hidden Test Categories
minimal inputrepeated valueslarger realistic input