SELECT emp.last_name , emp.salary , dep.department_name 

FROM   employees emp, departments dep 

WHERE emp.department_id = dep.department_id 

SELECT emp.last_name , emp.salary , dep.department_name 

FROM   employees emp JOIN departments dep 

ON  emp.department_id = dep.department_id

SELECT emp.last_name , emp.salary , dep.department_name , 

       loc.city

FROM   employees emp, departments dep, locations loc  

WHERE  emp.department_id = dep.department_id

AND

      dep.location_id = loc.location_id

SELECT emp.last_name , emp.salary , dep.department_name, 

       loc.city

FROM   employees emp JOIN departments dep

ON     emp.department_id = dep.department_id

                     JOIN locations loc  

ON     dep.location_id = loc.location_id

SELECT emp.last_name , emp.salary , job.grade_level

FROM   employees emp, job_grades job 

WHERE emp.salary BETWEEN job.lowest_sal AND job.highest_sal

SELECT emp.last_name , emp.salary , job.grade_level

FROM   employees emp JOIN  job_grades job 

ON emp.salary BETWEEN job.lowest_sal AND job.highest_sal

SELECT emp.last_name , emp.salary , dep.department_name 

FROM   departments dep , employees emp

WHERE  dep.department_id (+)  = emp.department_id

SELECT emp.last_name , emp.salary , dep.department_name 

FROM    departments dep RIGHT OUTER JOIN employees emp

ON      dep.department_id  = emp.department_id

SELECT emp.last_name , emp.salary , dep.department_name 

FROM    departments dep , employees emp

WHERE dep.department_id  = emp.department_id (+)

SELECT emp.last_name , emp.salary , dep.department_name 

FROM   departments dep LEFT OUTER JOIN employees emp

ON     dep.department_id  = emp.department_id

SELECT emp.last_name , emp.salary , dep.department_name 

FROM   departments dep FULL OUTER JOIN employees emp

ON     dep.department_id  = emp.department_id

SELECT emp.employee_id ,emp.last_name , emp.manager_id , 

       mng.last_name

FROM   employees emp , employees mng 

WHERE  emp.manager_id = mng.employee_id 

SELECT emp.employee_id ,emp.last_name , emp.manager_id , 

       mng.last_name

FROM   employees emp  JOIN employees mng 

ON     emp.manager_id = mng.employee_id

SELECT emp.last_name , emp.salary , dep.department_name 

FROM   employees emp JOIN departments dep 

ON     emp.department_id = dep.department_id

WHERE emp.department_id = 90

SELECT emp.last_name , emp.salary , dep.department_name 

FROM   employees emp  JOIN departments dep 

ON emp.department_id = dep.department_id

ORDER BY emp.salary DESC