![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
在雇员表employee中查询薪水在3000元至4000元的雇员的姓名和薪水,正确的语句是( ) A. SELECT 姓名,薪水 FROM employee WHERE 薪水>3000 OR 薪水<4000 B. SELECT 姓名,薪水 FROM employee WHERE 薪水>3000 AND 薪水<4000 C. SELECT 姓名,薪水 FROM employee WHERE 薪水>3000 LIKE 薪水<4000 D. SELECT 姓名,薪水 FROM employee WHERE 薪水 BETWEEN 3000 AND 4000