select
emp_no,
birth_date,
first_name,
last_name,
gender,
hire_date
from
(
    select
    emp_no,
    birth_date,
    first_name,
    last_name,
    gender,
    hire_date,
    dense_rank()over(order by hire_date desc) as rk
    from employees
) a
where rk = 3
order by emp_no asc;