查询哪些雇员的入职日期比雇员编号为101要早?

select employee_id 员工编号,hire_date 入职日期
from employees
where employee_id is not null
and year(hire_date) is not null
group by employee_id
having year(hire_date)<(select year(hire_date) from employees where employee_id=101);