One global top-spenders list hides the winners in each region

One company-wide top-spenders list crowns a single winner and hides every region's own best customer underneath it.

IntermediateRead 6 minDoing: 30 to 45 minutes once the completed-order totals exist, longer the first time you write a partitioned ranking query7 steps

▶ Start

What you'll have at the end

A ranked top-three list per region, with tie-breaking handled the same way in every region

Before you start

You need

Read access to a completed-orders table with a customer id and a dollar amount, plus a customers table carrying a region column, joined by that shared customer id.

Not covered

Picking just the one best customer per region, a narrower question a single-row-per-group shortcut can already answer.

Leans on

SQL Cheat SheetCarries the window-ranking functions, the CTE syntax, and the view syntax this whole report is built from.
PostgreSQL Cheat SheetCarries the one-row-per-group shortcut that would only answer a narrower single-winner version of this question.

7 steps

Where to go next

Leadership wants revenue grouped by region, not a spreadsheet of every order

for the region-level revenue totals to check this per-customer ranking against.

Checked 26 Aug 2026

Part of the SQL cookbook