SELECT AVG(成绩) FROM 成绩表 WHERE class<=3
SELECT AVG(成绩) FROM 成绩表 WHERE class<=3 GROUP BY class
SELECT AVG(成绩) FROM 成绩表 WHERE class<=3 order by class
SELECT AVG(成绩) FROM 成绩表 HAVING class <=3 GROUP BY class
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题