Write a SQL query to analyze sell-out by category, store, and week, and identify the top-performing locations for The Coca-Cola.
Use the provided product, store, and sell-out data. Exclude records with an unknown category or missing sale date. Return the top two location ranks within each category and week, including ties.
Output
- One row per included category, week, and top-ranked store
- Columns:
category, week_start, store_name, total_units, location_rank
- Sort by category, week, rank, and store name
