All Problems
39

Total Revenue per Customer

MediumJOINSUMGROUP BY

Problem Description

Write a SQL query to find total amount spent by each customer.

Expected Columns

  • customer_name
  • total_spent

Example Output

| customer_name | total_spent | |---------------|-------------| | Rajesh Kumar | 83200.0 | | Sunita Devi | 83850.0 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#39 Total Revenue per Customer
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results