OCP CBT Question 531

Please solve the following question.

You need to list the `first_name`, `last_name`, and `email` of all employees who work in departments located in the city 'Seattle'.

Relevant Table Structures
DESCRIBE employees;
Name                           Null?    Type
------------------------------ -------- -------------
FIRST_NAME                              VARCHAR2(20)
LAST_NAME                      NOT NULL VARCHAR2(25)
EMAIL                          NOT NULL VARCHAR2(25)
DEPARTMENT_ID                           NUMBER(4)

DESCRIBE departments;
Name                           Null?    Type
------------------------------ -------- -------------
DEPARTMENT_ID                  NOT NULL NUMBER(4)
LOCATION_ID                             NUMBER(4)

DESCRIBE locations;
Name                           Null?    Type
------------------------------ -------- -------------
LOCATION_ID                    NOT NULL NUMBER(4)
CITY                           NOT NULL VARCHAR2(30)

SELECT first_name, last_name, email FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE location_id IN (SELECT location_id FROM locations WHERE city = 'Seattle'));

SELECT e.first_name, e.last_name, e.email FROM employees e JOIN departments d ON e.department_id = d.department_id JOIN locations l ON d.location_id = l.location_id WHERE l.city = 'Seattle';

SELECT first_name, last_name, email FROM employees WHERE department_id IN (SELECT department_id FROM departments JOIN locations ON departments.location_id = locations.location_id WHERE locations.city = 'Seattle');

SELECT e.first_name, e.last_name, e.email FROM employees e WHERE EXISTS (SELECT 1 FROM departments d JOIN locations l ON d.location_id = l.location_id WHERE d.department_id = e.department_id AND l.city = 'Seattle');