题解 | 分析不同门店各类商品的库存情况和销售情况
分析不同门店各类商品的库存情况和销售情况
https://www.nowcoder.com/practice/5b9262a36724466ea1ae1f58187197d6
select si.store_id, store_name, product_category, inventory_quantity, sales_amount from sales_inventory si join stores s on si.store_id=s.store_id join products p on si.product_id=p.product_id where inventory_quantity<10 and sales_amount>5000 order by si.store_id, si.product_id
查看21道真题和解析
