题解 | 分析不同门店各类商品的库存情况和销售情况

SELECT 
    s.store_id,
    s.store_name,
    p.product_category,
    si.inventory_quantity,
    si.sales_amount
FROM sales_inventory si
INNER JOIN stores s 
    ON s.store_id = si.store_id
INNER JOIN products p 
    ON p.product_id = si.product_id
WHERE si.inventory_quantity < 10 
  AND si.sales_amount > 5000
ORDER BY 
    s.store_id ASC, 
    p.product_id ASC;