Return username and SUM(total_amount) AS total_spent for users whose account_status is 'active' usin

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

Domain

SQL

Difficulty

medium

Problem

Return username and SUM(total_amount) AS total_spent for users whose account_status is 'active' using INNER JOIN and GROUP BY. Only return users with total_spent over 50. Order by total_spent descending, then username.

Practice This Problem

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