面试题：MySQL中检索多个列数据的复杂条件筛选

Question

有一张员工表employees，列有employee_id、department、salary、hire_date。现在要检索出销售部门（department为'sales'）且入职日期在2020年之后，薪资高于平均薪资的员工的employee_id和hire_date，你会怎么写SQL语句？

Answer 1

SELECT employee_id, hire_date
FROM employees
WHERE department ='sales'
  AND hire_date > '2020-01-01'
  AND salary > (SELECT AVG(salary) FROM employees);