New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
Not the best sellers overall. The best sellers inside each category.
What you'll have at the end
A ranked list showing exactly three products per category, checked by hand against one category
You need
A table of order line items, each row showing a category, a product, a status such as completed, cancelled or returned, a quantity and a unit price.
Not covered
Deciding which historical time window counts as best sellers (this week, this quarter, all time): pick the window first, since this recipe ranks whatever period the raw order lines already cover.
Combine three monthly sales exports into one table with UNION
go there first if the raw order lines still arrive as separate monthly export files instead of one combined table
Customers sorted into spending deciles for a campaign list
go there when the ask is splitting every customer into ranked buckets, not a fixed top three inside each category
Checked 26 Aug 2026
Part of the SQL for Data Analysis cookbook