Given an inventory table with warehouse_id, product_id, date, and quantity, write a query that identifies products that were out of stock in at least one warehouse while overstocked (200% of average) in another on the same date.

Question

Given an inventory table with warehouse_id, product_id, date, and quantity, write a query that identifies products that were out of stock in at least one warehouse while overstocked (>200% of average) in another on the same date.

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

Given an inventory table with warehouse_id, product_id, date, and quantity, write a query that identifies products that were out of stock in at least one warehouse while overstocked (>200% of average) in another on the same date.

Practice more