Big Spenders

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

Marketing is launching a loyalty tier program and needs to identify high-value customers. For each user, calculate their total spending and the number of transactions they have made. Only include users whose lifetime spending exceeds five hundred dollars. List them from highest spender to lowest.

Summary

The whale list.

Practice This Problem

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