You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following queries...

Extracted text: You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following queries will be correct? EMPLOYEES Туре NOT NULL NUMBER(4) VARCHAR2(10) Name Null? EMP ID FIRST NAME VARCHAR2(10) VARCHAR2(9) VARCHAR2(4) LAST NAME JOB MGR HIRE DATE DATE SALARY NOT NULL NUMBER COMM PCT NUMBER(7,2) DEPT ID NUMBER(2) DEPARTMENTS Туре NUMBER VARCHAR2(20) VARCHAR2(20) Name Null? DEPT ID DEPT NAME DEPT LOC O SELECT first_name, last_name FROM employees WHERE last_name = 'Butcher' And first_name = 'Jessica'; O SELECT first_name, last_name FROM employees WHERE department =100; O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher'); O SELECT first_name, last_name FROM employees WHERE department (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher' AND department = 100 AND employee_id = 40);