YH-0.0.4-SNAPSHOT

문제재직 중인 개발(Development)부서의 사원 목록과 가장 최신 연봉 정보를 출력SELECT a.emp_no, CONCAT(a.first_name, ' ', a.last_name) AS emp_name, b.salaryFROM employees AS aJOIN dept_emp AS c ON a.emp_no = c.emp_noJOIN departments AS d ON c.dept_no = d.dept_noJOIN salaries AS b ON a.emp_no = b.emp_noWHERE d.dept_name = 'Development' AND c.to_date > now() AND b.from_date = (..

문제to_date가 1998년도인 연봉 상위 10% 사원의 정보 조회WITH salary_ranked AS ( SELECT a.emp_no, a.first_name, a.last_name, b.salary, percent_rank() OVER (ORDER BY b.salary DESC) AS percentile FROM employees AS a JOIN ( SELECT emp_no, salary FROM salaries WHERE YEAR(to_date) = 1998 -- 연도 필터링 ..

문제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;