模糊查询与分组查询III

模糊查询与分组查询

SELECT avg(gongjili),classid from honor GROUP BY classid HAVING avg(gongjili)>100

在这里插入图片描述



SELECT avg(gongjili),classid from honor GROUP BY classid HAVING avg(gongjili)>100
-- SELECT * FROM honor WHERE gongjili >100
-- SELECT sex,classid,COUNT(id) FROM honor GROUP BY  sex,classid
-- SELECT classid ,COUNT(id) FROM honor GROUP BY classid
-- SELECT caozuo,COUNT(id) FROM honor GROUP BY classid
-- SELECT caozuo,COUNT(id) FROM honor GROUP BY caozuo
-- SELECT avg(gongjili),classid from honor GROUP BY classid HAVING avg(gongjili)>100
-- SELECT * FROM honor WHERE gongjili >100
-- SELECT sex,classid,COUNT(id) FROM honor GROUP BY  sex,classid
-- SELECT classid ,COUNT(id) FROM honor GROUP BY classid
-- SELECT caozuo,COUNT(id) FROM honor GROUP BY classid
-- SELECT caozuo,COUNT(id) FROM honor GROUP BY caozuo
SELECT id AS 编号,name AS 姓名,jineng AS 技能,pifu AS 皮肤,
name1 AS 召唤师,cid AS 英雄代号,time AS 生日,caozuo AS
难易程度,gongjili AS 攻击力,classid AS 班级, sex AS 性别 FROM honor