Kings of the Aisle

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

The merchandising team is reviewing which product owned each category this year. For every category, surface the single product with the highest total sales, listed from the biggest earner down.

Summary

Every category crowns exactly one winner. Go find them.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.