task Correlated subqueries · medium

Big spenders for their region

A shopper's spend is the sum of quantity × unit_price over their delivered orders. Return name, region and spend for shoppers whose spend is greater than the average spend of shoppers in the same region.

what to return

Columns

nameregionspend in this order

Rows

6 rows · any order

Watch for

Only shoppers with at least one delivered order are part of a region's average.

Shoppers with no region are excluded.

Round spend to 2 decimals (compare unrounded values).

Skill

Compare each row with an aggregate of its own group. Refresher: Revenue across tables →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Sample rows from each table. Each column shows its type underneath; → marks a link to another table.