Top Customer per City

Write a SQL query to find the customer who spent the most in each city.

Expected Columns

• city
• customer_name
• total_spent

Example Output

| city | customer_name | total_spent | |------|---------------|-------------| | Ahmedabad | Geeta Patel | 1150.0 | | Bangalore | Amit Sharma | 5300.0 | | ... | ... | ... |