SQL 查询语句：统计玩家物品数量并筛选

SELECT PlayerId,itemcfg.ItemType,SUM(Count) as item_SUM FROM item LEFT JOIN itemcfg ON itemcfg.Id = item.ItemCfgId WHERE 1=1 GROUP BY PlayerId,ItemType HAVING CASE itemcfg.ItemType WHEN 0 THEN item_SUM >= 50 ELSE NONE END CASE; ORDER BY item_SUM DESC