2025.01.11(토) 1일 1쿼리

Quiz 1) 최연소 부서 매니저의 이름, 성별, 근무 연수를 조회하시오.

SELECT 
  CONCAT(e.first_name, ' ', e.last_name ) as 'name',
  gender,
  TIMESTAMPDIFF(YEAR, e.hire_date, NOW()) AS workYears
FROM dept_manager AS dm
JOIN employees AS e ON e.emp_no = dm.emp_no 
ORDER BY birth_date DESC 
LIMIT 1;