View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY
tables.
The query should display the employee IDs of all the employees who have held the job
SA_MAN at any time during their tenure.
Choose the correct SET operator to fill in the blank space and complete the following
query.
SELECT employee_id
FROM employees
WHERE job_id = ‘SA_MAN’
________________
SELECT employee_id
FROMjob_history
WHERE job_id=’SA_MAN’
A.
UNION
B.
MINUS
C.
INTERSECT
D.
UNION ALL