문제최신 연봉이 부서 최신 연봉의 평균보다 높은 사원을 조회하세요.WITH LatestSalaries AS ( SELECT emp_no, salary, ROW_NUMBER() OVER (PARTITION BY emp_no ORDER BY from_date DESC) AS rn FROM salaries),avgSalary AS ( SELECT b.dept_no, AVG(a.salary) AS avg_salary FROM (SELECT emp_no, salary FROM LatestSalaries WHERE rn = 1) AS a JOIN dept_emp AS b ON a.emp..