Whale Watch

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

Domain

SQL

Difficulty

easy

Problem

The revenue operations team is building an account health dashboard and needs to identify high-value users. For each user, calculate their total spending, the number of transactions, and the average transaction size. Only surface users whose total spending exceeds five hundred dollars, sorted from biggest spender to smallest. Round the average to two decimal places.

Practice This Problem

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