查找与用户指定雇员ID的部门、薪金相同的所有雇员的姓名、部门、薪金,以下那条语句可以实现?( )
SELECT name, department_id, salary FROM employee WHERE (department_id, salary) IN (SELECT department_id, salary FROM employee WHERE employee_id = &1) AND bonus IS NULL;
SELECT name, department_id, salary FROM employee WHERE (department_id, salary, bonus) = (SELECT department_id, salary, bonus FROM employee WHERE employee_id = &1) AND bonus = NULL;
SELECT name, department_id, salary FROM employee WHERE (department_id, salary) = (SELECT department_id, salary FROM employee WHERE employee_id = &1) AND bonus IS NULL;
SELECT name, department_id, salary FROM employee WHERE (SELECT department_id, salary FROM employee WHERE employee_id = &1) AND bonus = 0;