[SQL문제풀기] Salaries Differences

문제

StrataScratch - Salaries Differences

StrataScratch

https://platform.stratascratch.com/coding/10308-salaries-differences?code_type=3

MySQL

내가 작성한 정답

with a as (select max(e.salary) s
            from db_employee e
            join db_dept d on e.department_id = d.id and d.department in ('engineering','marketing')
            group by e.department_id)
select max(s)- min(s)
from a;