select Sno ,avg(Grade) from sc_831 group by Sno
having avg(Grade)>(select avg(Grade) from student_831,sc_831 where Sname='杨春容');
第一次写把“容”写成“荣”了
死活查不出来
真的会谢
select Sno ,avg(Grade) from sc_831 group by Sno
having avg(Grade)>(select avg(Grade) from student_831,sc_831 where Sname='杨春容');
第一次写把“容”写成“荣”了
死活查不出来
真的会谢