select emp_no,birth_date,first_name,last_name,gender,hire_date
from employees
where emp_no % 2 = 1
and last_name != 'Mary'
order by hire_date desc

SQL214 查找employees表emp_no与last_name的员工信息

where 字段 % 2 = 1：对二取模的余数为一即为奇数即可筛选出员工编号为奇数的员工