JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Top Customer per Product Category | Algorithm

HardsubquerySQL

Top Customer per Product Category

A retail analytics manager wants to recognize top customers by category for a loyalty program. They need to know which customer has spent the most on products in each category, based on the total value of their purchases (quantity multiplied by unit price).

Return

category : the product category customer_name : the name of the top-spending customer in that category total_spent : the total amount spent by that customer in the category Include all customers who tie for the highest spending in a category. Order the results by category (A-Z), then by customer_name (A-Z).

Expected output

First 3 of 5 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.