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

-- 逻辑拆解：筛选条件是-库存量＜10，销售额>5000。查询指标是商品类别、库存数量和销售额
SELECT 
    t2.store_id,
    t3.store_name,
    t1.product_category,
    t2.inventory_quantity,
    t2.sales_amount
FROM products t1
LEFT JOIN sales_inventory t2
ON t1.product_id = t2.product_id
LEFT JOIN stores t3
ON t2.store_id = t3.store_id
WHERE t2.inventory_quantity < 10
AND t2.sales_amount > 5000
ORDER BY t2.store_id,t1.product_id