方法)NOT LIKE
- last_name不为Mary
- 按照hire_date逆序排列
- emp_no为奇数
偶数 -- [expression]%2 = 0
SELECT * FROM employees WHERE emp_no%2=1 AND last_name NOT LIKE 'Mary' ORDER BY hire_date DESC;
SELECT * FROM employees WHERE emp_no%2=1 AND last_name NOT LIKE 'Mary' ORDER BY hire_date DESC;