Problem
A. List of cities and the name of their countries using a natural join
B. Cross join between the employees and departments tables showing employee names and department names
C. Use the USING clause to list of department names and their monthly costs (salaries added up)
D. List of employee last names and the department name they work for using ON clause
E. Listing of countries and the names of the departments located there
F. Using the HR database, list of all employees' last names and their department names, whether they belong to a department or not. Include employees even if they do not belong to a department. (Hint: use an OUTER JOIN)
G. List of employees' last names and their department names, include all department names even if they do not have employees (Hint: Use OUTER JOINS)
H. List of employees' last names and their department names, include all department names even if they do not have employees, and all employees' last names even if they do not belong to a department
I. Using the HR database list the last names of the employees and who their manager is
J. This time, using a hierarchical query, show a list of last names of employees and who their manager is.
K. Using Oracle proprietary syntax, list of every employee and their related job title sorted by job_title.
L. Using Oracle proprietary syntax, list of every employee and their related job title sorted by job_title.