Top Users by Recent Spend

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

Our loyalty program selects VIP tiers based on recent activity. Return the top 10 users by total spending in the last 30 days, only counting users with a positive total. Show user_id and their total spend, highest to lowest.

Summary

Big spenders in the last 30 days.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.