Question: Write SQL queries for the exercise c, d, e, f, g, h, i, and j base on the figure I uploaded. (c) Find the names

Write SQL queries for the exercise c, d, e, f, g, h, i, and j base on the figure I uploaded.

(d) For each project, list the project name and the total hours per week (by all employees) spent on that project.

(e) Retrieve the names of employees who work on every project.

(f) Retrieve the names of employees who do not work on any project.

(g) For each department, retrieve the department name, and the average salary of employees working in that department.

(h) Retrieve the average salary of all female employees.

(i) 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.

Write SQL queries for the exercise c, d, e, f, g, h,

Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Sex Salary Super ssn Fname Minit Lname Bdate Address B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia JenniferS Wallace 9876543211941-06-20 291 Berry, Bellaire, TXF 43000 888665555 4 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 AhmadVJabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 James EBorg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL JZelaya 999887777 1968-01-19 3321 Castle, Spring, TX F25000 987654321 4 DEPARTMENT DEPT LOCATIONS Dnumber Dnumber Dname Research Administration Headquarters Mgr ssn 333445555 987654321 888665555 Mgr start_date 1988-05-22 1995-01-01 1981-06-19 Dlocation Houston Stafford Bellaire Sugarland Houston 4 WORKS ON PROJECT Pname Pnumber Plocation Dnum ssn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 32.5 ProductX ProductY ProductZ Computerization10Stafford Reorganization Newbenefits Bellaire 5 Sugarland 5 3 40.0 3 Houston 4 Houston Stafford 4 DEPENDENT Dependent_name Sex Relationship ssn 30.0 333445555 333445555 Theodore 333445555 Joy 987654321 123456789 123456789 123456789 F 1986-04-05 Daughter M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M 1988-01-04 Son F 1988-12-30 Daughter F 1967-05-05 Spouse 35.0 Abner Michael ice Elizabeth 20.0 20 NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

* PROBLEM #1 DOWN BELOW * ** PROBLEM #2 ARE THE EXERCISES CIRCLED DOWN BELOW ** Ms. Excel Practice Assignment 5 1. Create a Ms. Excel file using the Project Timeline template and enter the following...

file tax form for filing jointly with married couple with children CORRECTED (if checked) PAYER'S name, street address, city or town, state or province, country, ZIP or foreign postal code, and...

Could you take a look at the attached tax forms and see if I filled them out correctly. It is a group assignment, and I only have to provide IRS Forms 3800 and 5884. I'm also attaching the story...

Please help me with the following partnership income tax return project. Data and applicable forms are attached. Christy Albright and Dan Ralls formed the Charter Company on 11/30/2006, and chose a...

I could use some assistance on preparing an S Corporation Tax Return. The details are in the attached file. Acct 6113 S Corporation Due Date April 28, 2014 This problem is worth 100 points Prepare...

Len and Christy Vole, ages 42 and 39 respectively, are married and file jointly in 2014. Len is a contractor operating as a sole proprietorship (EIN 11-1111111). Christy is employed, earning $24,000...

Please Help me complete this partnership tax return. Attached are the problem and necessary forms, including Form 1065, 1125-A, K-1, 4562, 4797, 8825, 8949, and Schedule B-1 and D of the 1065. 1065...

This question involves the use of AGGREGATE linear PYTHOIN regression on the Auto data set. (a) Perform a simple linear regression with mpg as the response and horsepower as the predictor. Describe...

An air sample containing H2S at a concentration of 100 ppm is brought into contact with a sample of pure water at 25C. After equilibrium has been obtained, the H2S concentration in the water sample...

The diagram below represents a process where two components are made at stations A1 and A2 (one component is made at A1 and the other at A2). These components are then assembled at station B and...

1 . Red circle health is evaluating Project B . In years 4 of the project, the tax rate is expected to be 1 5 percent and the project is expected to have relevant revenue of $ 3 5 9 0 0 0 , relevant...

Sheffield Corporation earned $ 4 1 0 , 0 0 0 during a period when it had an average of 1 0 0 , 0 0 0 shares of common stock outstanding. The common stock sold at an average market price of $ 1 8 per...

2. Inquire about how you would be using SQL and Microsoft Office tools for the job and what skills you would be expected to demonstrate. Bring samples of the work you have done with this software....

2. Have you worked on any systems development projects? If so, what exactly did you do? What systems development practices did you use?

4. Which Microsoft Office tools have you used? What kinds of problems have you used these tools to solve?