Top Percentile Spenders
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L7
Problem
Return the user IDs and total spend for customers who fall in the top 1% by total transaction amount over the last 7 days.
Summary
Top 1% of users by total spend via percentile bucketing.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.