solulubeta
Sign in
SQL / Groups, conditions & dates
04.10 · SQL

Spending by city

Return city and total_spent (the sum of total_price of all sales to customers from that city), highest total first. Only cities whose customers bought something.

Medium 3 min Pro

This lesson is part of solulu Pro

Return city and total_spent (the sum of total_price of all sales to customers from that city), highest total first. Only cities whose customers bought something.

Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 43 of 77 · updated 2026-10-12