select *
from
(select *
from employees
order by hire_date desc
limit 3) as subquery
--建立一个subquery来查询入职倒数前三的人员

order by hire_date
limit 1;

--在这入职倒数前三的人中查找入职倒数第三的