Skip to content

Learn Functions Examples Practice Interview Cheatsheet Blog Playground

hard problems

Authors and Their Books Best Customer Per Category Books With Author and Publisher Customer Order Date Gaps Running Total of Customer Spend Dense Rank Salaries Company-Wide Departments Above Company Average Departments Above Average Salary Employees and Their Managers Employee Rank Within Department Manager vs Individual Contributor Pay Grade Trend Per Term Monthly Order Trend Movie Rank Per Genre Movies Above Their Genre's Average Budget Movies Above Genre Midpoint Pivot Order Status Counts Rank Students Within Each Course Manager Chain Depth Running Revenue Over Time Cumulative Salary Per Department Students Above Course Average Top Spender Per City

Home

Top Spender Per City

hardstorewindowcte

Top Spender Per City

Problem

Return the top-spending customer (name, city, total_spend) within each customer city.

Try It

Loading playground environment...

Hint

Solution

On this page

Problem
Try It
Hint
Solution

The definitive resource for learning SQL, from your first SELECT to advanced window functions, with a real database running in your browser.

Learn Functions Examples Practice Interview Cheatsheet Blog Playground About Contact

© 2026 SQLSimplified. Learn SQL by doing.