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

#查询每个门店库存数量小于 10 且销售额超过 5000 的商品类别、库存数量和销售额。查询出来的数据先按照门店 ID 升序排列，再按照产品ID 升序排列。
select a.store_id,store_name,product_category,inventory_quantity,sales_amount
from stores as a
inner join sales_inventory as b
on a.store_id = b.store_id
inner join products as c
on b.product_id = c.product_id
where inventory_quantity < 10 and sales_amount > 5000
order by a.store_id,c.product_id