sy2_1_7.sql

关于SQL数据库的实验代码和程序及一些函数的应用

select deptno,avg(bonus)
       from pay,person
       where pay.no=person.no and year=2005 and month=1
       group by deptno
       having avg(bonus)>=400
       order by avg(bonus)