oracle数据库、单个子查询返回多行是什么意思？

select dept_id from s_emp
where (select avg（salary）from s_emp group by dept_id)

(select avg(salary) from s_emp)