19.sql

来自「大学时做的数据库实验」· SQL 代码 · 共 7 行

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