Write a query to display the name, department number, and salary of any employee whose department number and salary match the department number and salary of any employee who earns a commission.

Display the name, department name, and salary of any employee whose salary and commission match the salary and commission of any employee located in Dallas.

Create a query to display the name, hire date, and salary for all employees who have both the same salary and commission as Scott.

Create a query to display the employee that earns a salary that is higher than the salary of all of the clerks. Sort the results on salary from highest to lowest.