19.sql

大学时做的数据库实验

select student.*,sc. grade
from student,sc
where student.sno in(select sno  from sc where sclass=1
                  group by sno  
having(avg(grade)>85))
and sc.sno=student.sno  and student.sclass='1'  and sc.sclass=student.sclass