Obtaining data from more than one table using various types of joins including Equijoins, Non-Equijoins,

Outer Joins and Self Joins.

Write a query to display the name, department number, and department name for all employees.

Create a unique listing of all jobs that are in department 30. Include the location of the department 30 in the output.

Write a query to display the employee name, department name, and location of all employees who earn a commission.

Display the employee name and department name for all employees who have an 'A' in their name.

Write a query to display the name, job, department number, and department name for all employees who work in DALLAS.

Display the employee name and employee number along with their manager's name and manager number. Label the columns Employee, Emp#, Manager, and Mgr#, respectively.

Modify the previous query to display all employees including King, who has no manager. Note, the 3rd and 4th fields for King will display as empty.

Create a query that will display the employee name, department number, and all the employees that work in the same department as a given employee. Give each column an appropriate label.

Show the structure of the SALGRADE table.

Create a query that will display the name, job, department name, salary, and grade for all employees.

Create a query to display the name and hire date of any employee hired after employee Blake.

Display all employees' names and hire dates along with their manager's name and hire date for all employees who were hired before their managers. Label the columns Employee, Emp Hire Date, Manager, and Mgr Hire Date, respectively.