Please help with this computer science homework problem. Please include screenshots of the outputs form 1-8.

Using the Company database in Oracle, construct SQL queries for the following (note: I will make the files (scripts) to create and populate the Company database available on Idisore shortly):

List the last name and address of managers who have a dependent with the same first name as themselves.

Retrieve the names of all employees who are directly supervised by Franklin Wong.

Retrieve the names of employees in the Research department who work more than 20 hours per week on the Computerization project.

List the last names of all supervisors who have no dependents.

For each department, retrieve the department name and the minimum salary for all employees working in that department.

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.

Retrieve the average salary of female employees who work more than 20 hours on projects.

Retrieve the names of employees who work on every project that John Smith works on.

Find the names and addresses of employees who work on at least one project located in Houston, but whose department has no location in Houston.

Create a view that has the employee name, supervisor name, and employee salary for each employee who works in the Research department.

Create a view that has project name, controlling department number, number of employees, and total hours worked per week on the project (group by project name).

First 1-8, do query result and screenshot, not for view