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

with t1 as 
(select store_id,product_id,inventory_quantity,sales_amount
from sales_inventory si
where inventory_quantity<10 and sales_amount>5000)
select t1.store_id,store_name,product_category,inventory_quantity,sales_amount
from t1
join stores using(store_id)
join products using(product_id)
order by t1.store_id,product_id