Set Operations: UNION, INTERSECT, and EXCEPT

UNION

SELECT name FROM employees
UNION
SELECT name FROM contractors;

INTERSECT (Simulated)

SELECT name FROM employees
WHERE name IN (SELECT name FROM contractors);

EXCEPT (MINUS Simulation)

SELECT name FROM employees
WHERE name NOT IN (SELECT name FROM contractors);