Select EMP_ID, F_NAME, L_NAME, SALARY from employees
where SALARY < (select AVG(SALARY) from employees);
select EMP_ID, SALARY,
(select AVG(SALARY) from employees) AS AVG_SALARY from employees;
select * from (select EMP_ID, F_NAME, L_NAME, DEP_ID from employees) AS EMP4ALL;

Select * from employees where DEP_ID IN
(select DEPT_ID_DEP from departments);

Select * from employees where DEP_ID IN
(select DEPT_ID_DEP from departments where LOC_ID='L0002');

Select DEPT_ID_DEP, DEP_NAME from departments
where DEPT_ID_DEP IN
(select DEP_ID from employees where salary > 70000);

select * from employees, departments;

Select * from employees, departments
where employees.DEP_ID = departments.DEPT_ID_DEP;

Select * from employees E, departments D
where E.DEP_ID = D.DEPT_ID_DEP;

Select employees.EMP_ID, departments.DEP_NAME
from employees E, departments D
where E.DEP_ID = D.DEPT_ID_DEP;

Select E.EMP_ID, D.DEP_NAME
from employees E, departments D
where E.DEP_ID = D.DEPT_ID_DEP;