SELECT 
    `emp_no`     
    ,`birth_date` 
    ,`first_name` 
    ,`last_name`  
    ,`gender`     
    ,`hire_date`  
FROM 
(
    SELECT 
        *, 
        dense_rank() over( ORDER BY hire_date DESC ) AS rk 
    FROM 
        employees 
) AS employee_ext
WHERE 
    rk = 3