--create a query to display the name, salary and commission for all employees who earn commisiions. sort data in desending order of salary and commission -- create a query to display the name , job, and hiredate for the employees whoes names are BLAKE and SMMITH. order by ascending order by start date -- create a query to display the name, job and salary for all employees whose job is eaither that of a salesman or clerk and whoes salary is not equal to 2500$ , 3500$ or 7000$ -- create a query to display the number of employees working under the same manager exclude who have no manager -- create a query to display the name, job, and salary of any employee who have both the same salary and commission of any employee working in research department -- create a query to display the name and hiredate for all employees who were hired between 1980 and 1981