1
解题:
select(
(select max(salary)from db_employee
join db_dept on
db_employee.department_id = db_dept.id
where department = 'marketing')
-
(select max(salary) from db_employee
join db_dept on
db_employee.department_id = db_dept.id
where department = 'engineering')) as salary_difference
2 ![在这里插入图片描述](https://img-blog.csdnimg.cn/b5ce6bb85d254309adc03c668f2b2379.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5ZCs6K-06KW_5L2z5L2z6Zq-5b6X5b6I,size_20,color_FFFFFF,t_70,g_se,x_16)
解题:
select id,first_name,last_name,department_id, max(salary)from ms_employee_salary
group by id,first_name,last_name,department_id
order by id