select
    emp_no,
    birth_date,
    first_name,
    last_name,
    gender,
    hire_date
from
    (
        select
            *,
            dense_rank() over (
                order by
                    hire_date desc
            ) `rank`
        from
            employees
    ) e
where
    e.rank = 3;