题解 | #查找emp_no与last_name的员工信息#

select emp_no,birth_date,first_name,last_name,gender,hire_date
from employees
where mod(emp_no,2) and last_name <> 'Mary'
order by hire_date desc