Leher C o COMPANY d The SOL SOLM can be dow b oard wideo with the references. You need to modify the m leasumber of changes to the schema get you Again, the 2. A creating the pa th COMPANY SQL int ents can be downloaded from the Blac Once again, the given to you will ne edu solution with fewe changes to the SOL make any changes to the schema di problem to w e Provide a You should not his problem 3. Each Problem Spes each: SX1260 Specify the following queries on the from above wash of each query as would apply to the database A w the result a. Retrieve the names of employees in departments who work s 10 hours per week on the ProductX project b. List themes of all employees who have a dependent with the met as themselves c. Find the names of all employees who are directly supervised by Wong d. For each project is the project me and the total hours per week by employees) spent on the project e. Retrieve the names of all employees who work on every project 1. Recieve the names of all employees who do not work on any project For each department the department and the way of all employees working in the department I. Retrieve the average salary of all female employees Find the name and of all employees who wo t c a in Houston but whose department has no location in House is the last of all de n who have dende an d For each der whose avage employees der and the role o f employees. Can we specify this querySQL 1. Create the tables for the COMPANY database in Oracle SQL. Make sure that all the constraints are enforced. The SQL statements can be downloaded from the Blackboard link company_create.htm. The script given to you will not compile because of circular references. You need to modify the script to make it work. Provide a solution with the least number of changes to the schema given to you. 2. After creating the tables, populate the COMPANY database with the data. Again, the SQL insert statements can be downloaded from the Blackboard link company_insert.htm. Once again, the script given to you will not execute due to circular references. Provide a solution with fewest changes to the SQL statements provided to you. You should not make any changes to the schema created in problem 1 to solve this problem. 3. Each Problem 5pts each; 5X12 = 60 Specify the following queries on the from above database schema. Also, show the result of each query as it would apply to the database. a. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the 'ProductX' project. b. List the names of all employees who have a dependent with the same first name as themselves. C. Find the names of all employees who are directly supervised by 'Franklin Wong'. d. For each project, list the project name and the total hours per week (by all employees) spent on the project. e. Retrieve the names of all employees who work on every project. f. Retrieve the names of all employees who do not work on any project. g. For each department, retrieve the department name and the average salary of all employees working in that department. h. Retrieve the average salary of all female employees. i. Find the names and addresses of all employees who work on at least one project located in Houston but whose department has no location in Houston. j. List the last names of all department managers who have no dependents. k. 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. 1. Suppose that we want the number of male employees in each department rather than all employees. Can we specify this query in SQL? Why or why not. Leher C o COMPANY d The SOL SOLM can be dow b oard wideo with the references. You need to modify the m leasumber of changes to the schema get you Again, the 2. A creating the pa th COMPANY SQL int ents can be downloaded from the Blac Once again, the given to you will ne edu solution with fewe changes to the SOL make any changes to the schema di problem to w e Provide a You should not his problem 3. Each Problem Spes each: SX1260 Specify the following queries on the from above wash of each query as would apply to the database A w the result a. Retrieve the names of employees in departments who work s 10 hours per week on the ProductX project b. List themes of all employees who have a dependent with the met as themselves c. Find the names of all employees who are directly supervised by Wong d. For each project is the project me and the total hours per week by employees) spent on the project e. Retrieve the names of all employees who work on every project 1. Recieve the names of all employees who do not work on any project For each department the department and the way of all employees working in the department I. Retrieve the average salary of all female employees Find the name and of all employees who wo t c a in Houston but whose department has no location in House is the last of all de n who have dende an d For each der whose avage employees der and the role o f employees. Can we specify this querySQL 1. Create the tables for the COMPANY database in Oracle SQL. Make sure that all the constraints are enforced. The SQL statements can be downloaded from the Blackboard link company_create.htm. The script given to you will not compile because of circular references. You need to modify the script to make it work. Provide a solution with the least number of changes to the schema given to you. 2. After creating the tables, populate the COMPANY database with the data. Again, the SQL insert statements can be downloaded from the Blackboard link company_insert.htm. Once again, the script given to you will not execute due to circular references. Provide a solution with fewest changes to the SQL statements provided to you. You should not make any changes to the schema created in problem 1 to solve this problem. 3. Each Problem 5pts each; 5X12 = 60 Specify the following queries on the from above database schema. Also, show the result of each query as it would apply to the database. a. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the 'ProductX' project. b. List the names of all employees who have a dependent with the same first name as themselves. C. Find the names of all employees who are directly supervised by 'Franklin Wong'. d. For each project, list the project name and the total hours per week (by all employees) spent on the project. e. Retrieve the names of all employees who work on every project. f. Retrieve the names of all employees who do not work on any project. g. For each department, retrieve the department name and the average salary of all employees working in that department. h. Retrieve the average salary of all female employees. i. Find the names and addresses of all employees who work on at least one project located in Houston but whose department has no location in Houston. j. List the last names of all department managers who have no dependents. k. 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. 1. Suppose that we want the number of male employees in each department rather than all employees. Can we specify this query in SQL? Why or why not