有关联的，用sno和cnoselect dept, sc.cname, avg(grade)from student,course,scwhere student.sno=sc.sno and sc.cno=course.cnogroup by dept, sc.cname
