Skip to content
SQLSimplified
hardstorewindowcte

Best Customer Per Category

Problem

For each product category, return the single customer who spent the most, with category, customer name, and total_spend.

Try It

Store (Customers/Orders/Products)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems