In this lab, you are going to practice and write different DQL queries. Before starting, you need to install Oracle Human Resources (HR) Dataset which is a sample data based provided by Oracle for learning purposes. HR Dataset Description In the Human Resource (HR) records, each employee has an identification number, e-mail address, job identification code, salary, and manager. Some employees earn commissions in addition to their salary. The company also tracks information about jobs within the organization. Each job has an identification code, job title, and a minimum and maximum salary range for the job. Some employees have been with the company for a long time and have held different positions within the company. When an employee resigns, the duration the employee was working, the job identification number, and the department are recorded. The sample company is regionally diverse, so it tracks the locations of its warehouses and departments. Each employee is assigned to a department, and each department is identified either by a unique department number or a short name. Each department is associated with one location, and each location has a full address that includes the street name, postal code, city, state or province, and the country code. In places where the departments and warehouses are located, the company records details such as the country name, currency symbol, currency name, and the region where the country is located geographically. 1. Retrieve the department 10, department name, location 10, and city for each department from the HR schema. Hint weenoturalioin 2. Retrieve the employee iD, employee full name, salary, department ID, department Name, location ID, and the department's street address for all employees with a salary higher than $10000. 3. write a sal query to find the name of the country, city, and departments, which are running there. 4. Retrieve the last name of the employee and the last name of his/her manager. Sort the result according to the manager's last name. 5- Find all departments along with the emplovees who work for each department. Include those departments without any employees. Return department io, department name, empioyee's first name, and employee's last name 6. Retrieve the employee's ID, full name, salary. job title, manuger ID and managet full name for atl employees who work for a finance manager. 7. Retrieve all information about all the departments in the organization along with the manager name (if exists). 8. Write a SQL query to find the difference between the maximum salary of the job and the salary of the employees. Return job title, the job's max salary, employee name, employee salary and salary difference. 9. Write a 50t query to find those employees who earn less than the employee of 10 182. Return first name, last name and salary. 10-Write a SOL query to tind those employees who eam more than the average salary, Aleturn employee ID, first name, last name. 11-Write a 5Ql. query to find those employees who work in the same department where 'Clara' works. Exclude all those recoods where the tirst name is 'Clara'. Return first name, last name and hire date. 12-Write a SQL query to find those empleyees whose salary is higher than the salary of all employees whose job title is PU_MaN?. Retum employee ID, first name, last name, job id. 13. Write a SQL query ta find those employees who earn the highest salary in their department. Return department io, employee name, and salary. 14-Find the most recently hired emplovees in each department. Sort the result-set in descending order by hire date