All Problems
62

Top Spenders by City

MediumJOINSUMGROUP BY

Problem Description

Write a SQL query to find total spending by customer city.

Expected Columns

  • city
  • total_spending

Example Output

| city | total_spending | |------|----------------| | Mumbai | 83200.0 | | Delhi | 83850.0 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#62 Top Spenders by City
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results