Which of the following queries returns only the employees whose office IDs do not match any office IDs found in the offices table?

Question 10
Which of the following queries returns only the employees whose office IDs do not match any office IDs found in the offices table?

1 point

SELECT empl_id, name

FROM california_offices o

LEFT OUTER JOIN california_emp e ON e.office_id = o.office_id

WHERE e.office_id IS NULL;

SELECT empl_id, name

FROM california_emp e

LEFT OUTER JOIN california_offices o ON e.office_id = o.office_id

WHERE o.office_id IS NULL;

SELECT empl_id, name

FROM california_emp e

LEFT OUTER JOIN california_offices o ON e.office_id = o.office_id

WHERE office_id IS NULL;

SELECT empl_id, name

FROM california_offices o

LEFT OUTER JOIN california_emp e ON e.office_id = o.office_id

WHERE o.office_id IS NULL;

SELECT empl_id, name

FROM california_emp e

LEFT OUTER JOIN california_offices o ON e.office_id = o.office_id

WHERE e.office_id IS NULL;