select * from employees where (emp_no %2 =1) and last_name !="Mary" order by hire_date desc emp_no为奇数就是emp_no %2 =1 last_name 不为marry的信息则是!=，容易出错的是容易把emp_no %2 =1 写作emp_no %2==1