Please answer all parts

Display the employee name and department number of all employees in departments 10 and 30 in alphabetical order by name. 6. Create a query to display the name and salary of employees who earn more than $1500 and are in department 10 or 30 . Label the columns Employee and Monthly Salary, respectively. 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions