SELECT GenderplayerAvaterTypeCOUNT as avatar_AVG FROM playerSELECT AvaterTypeCount FROM player WHERE Gender != 0 GROUP BY AvaterType as avatar_COUNTWHERE 1=1 GROUP BY GenderAvaterType HAVING Gender !=

您可以使用以下查询来获取gender为1或2，avatertype为0-10对应的数量：

SELECT Gender, player.AvaterType, COUNT(*) as avatar_AVG FROM player WHERE Gender IN (1, 2) AND AvaterType BETWEEN 0 AND 10 GROUP BY Gender, AvaterType ORDER BY AvaterType