模糊查询与分组查询
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
-- SE