exists函数

查询部门员工平均工资大于2000的部门信息

select *
  from dept t
 where exists
 (select deptno
          from (select deptno, avg(sal) avg_sal from emp group by deptno)
         where avg_sal >= 2000
           and deptno = t.deptno);