select * 
from employees 
where emp_no %2 !=0 and last_name != 'Mary'
order by hire_date desc

没什么说的，按要求筛选就行