Supply Chain & OpsMedium
Classify SKUs into ABC segments based on revenue contribution.
Seen at: Walmart · Amazon · Blue Yonder
Given sku_sales(sku_id, revenue_12m), write SQL to classify SKUs into A / B / C segments: A = top 80% of revenue, B = next 15%, C = remaining 5%.
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Stuck? Peek at a hint
Reveals the model answer and the self-score rubric.