题解 | 分析不同门店各类商品的库存情况和销售情况
分析不同门店各类商品的库存情况和销售情况
https://www.nowcoder.com/practice/5b9262a36724466ea1ae1f58187197d6
select i.store_id,store_name,product_category,inventory_quantity, sales_amount from sales_inventory i join stores s on s.store_id=i.store_id join products p on p.product_id=i.product_id where inventory_quantity < 10 and sales_amount > 5000 order by i.store_id,i.product_id;
腾讯成长空间 5958人发布