[SQL문제풀기] Average Salaries

문제

StrataScratch - Average Salaries

StrataScratch

https://platform.stratascratch.com/coding/9917-average-salaries?code_type=3

내가 작성한 정답

MySQL, Oracle, PostgreSQL

select e.department, e.first_name, e.salary, d.s avg_salary
from (select department,avg(salary) s
        from employee
        group by department) d
join employee e on d.department = e.department;