面试题：MySQL WHERE子句中范围值与空值检查基础运用

Question

假设有一个名为`employees`的表，包含`salary`（薪资）和`department`（部门）字段。请写一条SQL语句，从该表中选择出薪资在5000到10000之间，且部门不为空的员工信息。

Answer 1

SELECT * FROM employees
WHERE salary BETWEEN 5000 AND 10000
  AND department IS NOT NULL;