我们有两张数据表，玩家表(Players)记录了玩家的角色等级，另一张是商品流水表(Records),记录了在某时某刻某种商品被某个玩家购买及购买的数量。 现在我们定义:角色等级<10的为玩家类型A, 10 级<=角色等级< 30级的为玩家类型B, 30级<角色等级的为玩家类型C。 请编写一条sq|语包，查询各商品被不同类型玩家所购买的次数，返回结果按商品唯一ID升序排序。使用MySQL

SELECT R.goods_id,
COUNT(CASE WHEN P.level < 10 THEN 1 END) AS type_a_num,
COUNT(CASE WHEN P.level >= 10 AND P.level < 30 THEN 1 END) AS type_b_num,
COUNT(CASE WHEN P.level >= 30 THEN 1 END) AS type_c_num
FROM Records AS R
LEFT JOIN Players AS P
ON R.player_id = P.player_id
GROUP BY R.goods_id
ORDER BY R.goods_id ASC;