[1일 1쿼리] 1일차 development부서에서 가장 높은 연봉을 받는 사람은?

 

select  s.emp_no , s.salary , e.first_name, e.last_name, e.gender 
from salaries as s
join dept_emp as m on s.emp_no = m.emp_no
join employees as e on e.emp_no = s.emp_no
where m.dept_no = (select dept_no from  departments as d where dept_name = 'Development') 
order by salary desc 
limit 1;