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