mysql 查询所有课程分数都低于60的学生姓名和分数，谢谢各位大神！
发布网友
发布时间：2022-04-13 06:55
我来回答
共1个回答
热心网友
时间：2022-04-13 08:24
select max(score) from grade select sum(score) from grade group by name limit(2,4) select sum(score) from grade group by name where sum(score) 150 select name,avg(sum(score)) from grade group by name where avg(sum(score)) > 60 and avg(sum(score)) < 80 select name,avg(sum(score)) from grade group by name where avg(sum(score)) 90 and sum(score) > 150 select count(*) from grade group by name where avg(sum(score)) 90 and sum(score) > 150追问您答的好像与我的问题不符呀
