How would i write the code to display questions 8, 9, and 10. thank you

SQL Assignment INSY 3304 Fall 2017 Due Nov 7 in class Penalty for late submission 1. Display all data from the Employee table Display last names and first names of all male employees Display last names, first names, and salaries of all employees sorted in descending order by salary Display department number (DNO), employee count, and total salaries for all departments. This query will display one row for each department Display last names, first names and department names for all employees Display project name, employee last name, number of hours worked sorted by project name in ascending order and employee last name in descending orde:r Display employee last name and supervisor's last name for all employees. Use appropriate column headings in your result. (Supervisor's SSN is available in SUPERSSN column of Employee table). (self joint) 2. 3. 4. 5. 6. 7. 8. Display first and last names of employees who have a dependent named Alice 9. Display first and last name of employee(s) who has (have) put in the most number of hours on any project 10. Display first and last names of employees that have two or more dependents Queries 8, 9 and 10 must be designed as subqueries. You are not permitted to use Views in your queries. Submission Kequirements This is an individual assignment. You may discuss the assignment with your friends but you must do it independently. The GTA and I will be glad to assistyou but will not reveal the complete solution to any problem before the due date. The following tables available in Omega under the account MAHAPATRA will be used in this assignment Table Name DEPARTMENT DEPENDENT EMPLOYEE WORKS ON In order to access these tables you must prefix the table name with MAHAPATRA. You may use the DESC command to get the table structures of the above tables