Question 1: Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.
Question 2: Display the last name, department name, and salary of any employee whose salary and commission match the salary and commission of any employee located in location ID 1700.
Question 3: Create a query to display the last name, hire date, and salary for all employees who have the same salary and commission as Kochhar.
Note: Do not display Kochhar in the result set
Question 4: Create a query to display the employees who earn a salary that is higher than the salary of all of the sales managers (JOB_ID = 'SA_MAN'). Sort the results on salary from highest to lowest.
Question 5: Display the details of the employee ID, last name, and department ID of those employees who live in cities whose name begins with T.
Question 6: Write a query to find all employees who earn more than the average salary in their departments.Display last name, salary, department ID, and the average salary for the department. Sort by average salary. Use aliases for the columns retrieved by the query as shown in the sample output.
Attachment:- Week9_Assignment.pdf