sy2_1_7.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 6 行

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)