Basis Data Modul 12 (Query)

1.
SELECT department_id
FROM employees
MINUS
SELECT department_id
FROM job_history
WHERE job_id LIKE 'ST_CLERK';

2.
SELECT country_id, country_name
FROM countries
minus
SELECT c.country_id, c.country_name
FROM countries c JOIN locations l ON c.country_id = l.country_id
JOIN departments d ON l.location_id = d.location_id;

3.
SELECT job_id, department_id
FROM employees
WHERE department_id IN (10, 50, 20)
UNION
SELECT job_id, department_id
FROM job_history
WHERE department_id IN (10, 50, 20);

4.
SELECT employee_id, job_id
from employees
INTERSECT
SELECT employee_id, job_id
from job_history