SELECT e.last_name,e.department_id,d.department_name
FROM employees e LEFT OUTER JOIN departments d
ON (e.department_id=d.department_id);


SELECT e.last_name,e.department_id,d.department_name
FROM employees e RIGHT OUTER JOIN departments d
ON (e.department_id=d.department_id);


SELECT e.last_name,e.department_id,d.department_name
FROM employees e FULL OUTER JOIN departments d
ON (e.department_id=d.department_id);
SELECT e.last_name,e.department_id,d.department_name
FROM employees e FULL OUTER JOIN departments d
ON (e.department_id=d.department_id);
SELECT last_name,job_id,salary
FROM employees
WHERE job_id=(SELECT job_id FROM employees
WHERE employees_id=141)

AND salary >(SELECT salary FROM employees
WHERE employees_id=143);

SELECT last_name,job_id,salary
FROM employees
WHERE salary=(select MIN(salary) FROM employees);











SELECT department_id,MIN(salary)
FROM employees
GROUP BY department id
HAVING MIN(salary) >
(select MIN(salary) FROM employees
WHERE department_id = 50);



SELECT employee_id,last_name
FROM employees
WHERE salary=
(select MIN(salary)
FROM employees
GROUP BY department_id);


 SELECT last_name,job_id
FROM employees
WHERE job_id=
(SELECT job_id
FROM employees
WHERE last_name='Haas');








SELECT employee_id,last_name,job_id,salary
FROM employees
WHERE salary<ANY
(SELECT salary
FROM employees
WHERE job_id='IT_PROG');
AND job_id<>'IT_PROG';








SELECT employee_id,last_name,job_id,salary
FROM employees
WHERE salary<ALL
(SELECT salary
FROM employees
WHERE job_id='IT_PROG')
AND job_id<>'IT_PROG';






SELECT employee_id,job_id
FROM employees
UNION
SELECT employee_id,job_id
FROM job_history;