Oracle数据库建表查询问题

Student(sno,sname,ssex,sbirth,stel,sdept)
Course(cno,cname,cpno,ccredit)
Sc(sno,cno,grade)
查找平均分为大于92分的学生学号，姓名，系别，并总分升序排序

不知道字段对不对，可以试试看

select S.sno, S.sname, sdept,  C.grade 
  from Student S
  left JOIN (select sc.sno sno, SUM(Sc.grade) grade  from Sc group by Sc.sno ) C
    ON S.sno = C.sno
 where   C.SNO IN
       (select A.sno from Sc A GROUP BY A.sno HAVING AVG(A.grade) > 92)
 order by C.grade ;