select *
from employees
where right(emp_no,1) in ('1','3','5','7','9') and last_name<>'Mary'
order by hire_date desc

可能并不简洁,但能解决实际问题