查询成绩低于该门课程的平均分的学生的学号 select Score.courseNo,Score.studentNo from (select avg(Score.score) as avgScore,courseNo from Score group by courseNo ) a left join Score on a.courseNo = Score.courseNo where score < avgScore group by Score.courseNo,Score.studentNo