select
  *
from
  employees
order by
  hire_date desc
limit
  1

写窗口函数写多了,陷到里面了

这里最晚入职,直接用order by 和 limit 即可