思路

法一：

# 1.先找出最晚入职的日期
select hire_date from employees
group by hire_date
order by  hire_date desc
limit 0,1;

# 2.再以最晚入职日期去匹配员工
select * from employees
where hire_date=
(
    select hire_date from employees
    group by hire_date
    order by  hire_date desc
    limit 0,1;
)

法二：

select * from employees
where hire_date =
(select max(hire_date) from employees)