查询两门及其以上不及格课程的同学的学号、姓名和平均成绩

select test.student.S_no,test.student.S_name,avg(test.score.S_score) avg_score from test.score
left join test.student on test.student.S_no=test.score.S_no 
  where test.student.s_no in 
    (select test.score.s_no from test.score where test.score.s_score<60 group by test.score.s_no having count(1)>=2)
group by test.student.s_no