MySQL多重嵌套查询

查询平均分（指某个学生选修的所有课程的平均分）高于“杨春容”的学生学号及成绩

SELECT Sno,AVG(Grade)
FROM sc
GROUP BY Sno HAVING AVG(Grade)>(SELECT AVG(Grade)
FROM sc
WHERE sc.Sno=(SELECT DISTINCT sc.Sno
FROM sc,student
WHERE student.Sname='杨春容' AND sc.Sno=student.Sno));