Supply Chain & OpsMedium
Write SQL to track OTIF by supplier and flag those below 90%.
Seen at: Kinaxis · Blue Yonder · Walmart · Amazon
Given orders(order_id, supplier_id, requested_date, requested_qty, sku_count_ordered) and shipments(order_id, received_date, received_qty, sku_count_received), write SQL that computes OTIF per supplier for the last 90 days and flags any supplier below 90%.
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.