SELECT employee_id, first_name, last_name, job_id FROM employees WHERE job_id IN (8, 9, 10) ORDER BY job_id;
SELECT employee_id, first_name, last_name, job_id FROM employees WHERE job_id NOT IN (7, 8, 9) ORDER BY job_id;
SELECT department_id FROM departments WHERE department_name = 'Marketing' OR department_name = 'Sales'
SELECT employee_id, first_name, last_name, salary FROM employees WHERE department_id IN (2, 8);
SELECT employee_id, first_name, last_name, salary FROM employees WHERE department_id IN ( SELECT department_id FROM departments WHERE department_name = 'Marketing' OR department_name = 'Sales' )
SELECT * FROM countries;
SELECT * FROM departments;
SELECT * FROM dependents;
SELECT * FROM employees;
SELECT * FROM jobs;
SELECT * FROM locations;
SELECT * FROM regions;
