请让使用者任意输入employee_id,列出该员工的last_name与salary
select employees.employee_id,
employees.salary,
employees.department_id,
avg_tmp.avgsalary
from employees
left outer join (select department_id, avg(salary) as avgsalary
from employees
group by department_id) avg_tmp
on employees.department_id = avg_tmp.department_id
热门标签: