Instructions: Use the table structure in HR schema. Show your codes and show the print screen of results.
1. Write a query to display all unique job codes from the EMPLOYEES table.
2. Display the last name concatenated with the job ID (separated by a comma and space) and name the column Employee and Title.
3. Display the last name, job ID, and start date for the employees with the last names of Matos and Taylor. Order the query in ascending order by start date.
4. List the last name and salary of employees who earn between $5,000 and $12,000 and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively.
5. Displays the last name and hire date for all employees who were hired in 1994.
6. Display the last name and job title of all employees who do not have a manager.
7. Displays the employee number, last name, and salary of all employees who earn more than the average salary. Sort the results in order of ascending salary.
8. Displays the last name, department number, and job ID of all employees whose department location ID is 1700.
9. Create a view showing total number of employees.
10. Create a view showing employee ID, first name, last name, hire date and salary.