Pro exercise

Top seller per category

Pick the best-selling product in each category with an explicit tie-break: highest units sold, then the smallest product ID. Products with unreadable sales can't compete.

window functions
ranking
ties