[SQL문제풀기] 부서별 평균 연봉 조회하기

문제

내가 작성한 정답

select d.dept_id, d.dept_name_en, round(avg(e.sal)) avg_sal
from HR_DEPARTMENT d
join HR_EMPLOYEES e on d.dept_id = e.dept_id
group by dept_id,dept_name_en
order by avg_sal desc