在商品表items中，统计不同类别的商品库存总数大于5000的商品类别和库存总数，并按照库存总数降序输出。

Question

select distinct category,inventory
from items
where inventory>=5000
order by inventory desc;
错哪了？

Answer 1

要统计每个类别的要分组呀，然后求和

SELECT category, SUM(inventory) as total_inventory
FROM items
GROUP BY category
HAVING total_inventory > 5000
ORDER BY total_inventory DESC;