面试题：MySQL中组合WHERE子句实现条件过滤

Question

假设有一个名为`employees`的表，包含字段`id`（员工编号）、`name`（员工姓名）、`department`（部门）、`salary`（薪资）。请写出SQL语句，查询出部门为‘研发部’且薪资大于5000的员工信息。

Answer 1

SELECT id, name, department, salary
FROM employees
WHERE department = '研发部' AND salary > 5000;