题解 | 分析不同门店各类商品的库存情况和销售情况
分析不同门店各类商品的库存情况和销售情况
https://www.nowcoder.com/practice/5b9262a36724466ea1ae1f58187197d6
诗人我吃
select a.store_id,store_name,product_category,inventory_quantity,sales_amount from sales_inventory a join stores b on a.store_id = b.store_id join products c on a.product_id = c.product_id where inventory_quantity < 10 and sales_amount > '5000' order by store_id,a.product_id
