YH-0.0.4-SNAPSHOT

부서 매니저였던 사원들의 현재 직급을 출력하시오SELECT e.emp_no, CONCAT(e.first_name, ' ', e.last_name), t.titleFROM dept_manager AS mJOIN employees AS e ON e.emp_no = m.emp_noJOIN titles AS t ON e.emp_no = t.emp_noWHERE m.to_date != '9999-01-01'AND t.to_date = '9999-01-01';

문제최신 연봉이 부서 최신 연봉의 평균보다 높은 사원을 조회하세요.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..

문제1부서별 직무의 사원수를 계산하는 쿼리문을 작성하세요.select c.dept_name, d.title, count(a.emp_no) as employee_count from employees as a join dept_emp as b on a.emp_no = b.emp_nojoin departments as c on b.dept_no = c.dept_nojoin titles as d on a.emp_no = d.emp_nogroup by c.dept_no, d.titleorder by b.dept_no;