select o.employee_id, o.last_name from employees o where o.salary > (select avg(i.salary) from employees i where i.department_id=o.department_id); 该SQL子查询将在什么时候执行？ 对于EMPLOYEES表的每条记录执行一次