SELECT GenderplayerAvaterTypeCOUNTFROM playerSELECT AvaterTypeCount FROM player WHERE Gender != 0 GROUP BY AvaterType as avatar_COUNTWHERE 1=1 GROUP BY GenderAvaterType HAVING Gender != 0ORDER BY Avat

您可以尝试使用子查询来计算每个AvaterType的数量，并将其与player表进行连接。以下是修改后的查询语句：

SELECT Gender, player.AvaterType, avatar_COUNT.count FROM player JOIN (SELECT AvaterType, COUNT(*) as count FROM player WHERE Gender != 0 GROUP BY AvaterType) as avatar_COUNT ON player.AvaterType = avatar_COUNT.AvaterType WHERE Gender != 0 ORDER BY player.AvaterType