HackerRank
[StrataScratch] Salaries Differences [MySQL]
치킨먹고싶어요
2022. 6. 22. 14:48
https://platform.stratascratch.com/coding/10308-salaries-differences?code_type=3
StrataScratch
platform.stratascratch.com
SELECT ABS(MAX(db_employee.salary) - (
SELECT MAX(db_employee.salary)
FROM db_employee
GROUP BY department_id
HAVING department_id = 4
))
FROM db_employee
GROUP BY department_id
HAVING department_id = 1
|
cs |