SQL面试50题-48
48、查询两门以上不及格课程的同学的学号及其平均成绩
SELECT s_id , AVG(s_score) FROM Score WHERE s_score < 60 GROUP BY s_id HAVING COUNT(s_score) >= 2
48、查询两门以上不及格课程的同学的学号及其平均成绩
SELECT s_id , AVG(s_score) FROM Score WHERE s_score < 60 GROUP BY s_id HAVING COUNT(s_score) >= 2
相关推荐