写出不及格门数大于等于2的学生的姓名和平均成绩
表:student
sid name
表:subject
cid cname
表:grade
sid cid cgrade
sql语句为:
select a.name,b.gr from student a, (SELECT sid,count(*) num,avg(cgrade) gr FROM GRADE where cgrade <60 group by sid) b where b.num>1 and a.sid=b.sid;