LeetCode-SQL-615. 平均工资：部门与公司比较

select department_salary.pay_month, department_id,
case
  when department_avg>company_avg then 'higher'
  when department_avg<company_avg then 'lower'
  else 'same'
end as comparison
from
(
  select department_id, avg(amount) as department_avg, date_format(pay_date, '%Y-%m') as pay_month
  from salary join employee on salary.employee_id = employee.employee_id
  group by department_id, pay_month
) as department_salary
join
(
  select avg(amount) as company_avg,  date_format(pay_date, '%Y-%m') as pay_month from salary group by date_format(pay_date, '%Y-%m')
) as company_salary
on department_salary.pay_month = company_salary.pay_month
;

最后

以上就是洁净荷花最近收集整理的关于LeetCode-SQL-615. 平均工资：部门与公司比较的全部内容，更多相关LeetCode-SQL-615.内容请搜索靠谱客的其他文章。