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

select s.Sid ,s2.Sname ,avg(s.score)
from sc s join student s2 on s.Sid =s2.Sid
group by s.Sid
having count(s.score<60 or null)>=2 ;