Specify and execute the following queries in Oracle SQL.

1. List the names of employees in department 5 who work more than 10 hours per week on the ProductX project.
2. List the names of employees who have a dependent with the same first name as themselves.
3. List the names of employees who are directly supervised by Franklin Wong.
4. List the names of employees who work on every project.
5. List the names of employees who do not work on any project.
6. List the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston.
7. List the names of department managers who have no dependents.
8. List the names of employees whose supervisor's supervisor has a social security number of 888665555.
9. List the name(s) of employee(s) with the lowest salary.
10. List the names of employees who work in the department that has an employee with the highest salary among all employees.
11. For each project, list the project name and the total hours per week (by all employees) spent on the project.
12. For each department, retrieve the department name and the average salary of all employees working in that department.
13. Retrieve the average salary of all female employees.
14. For each department whose average employee salary is more than $30,000, retrieve the department name and the number of employees working for that department.
15. Suppose that we want the number of male employees in each department rather than all employees (as in the previous query). Can we specify this query in SQL? Why or why not.

ORACLE DATABASE:

companySchema.sql
companyData.sql

SUBMISSION INSTRUCTIONS:

sudo handin 2 hw2