Question: please write SQL statement? (a) Retrieve the names of employee in department 5 who work more than 10 hours per week on the ProductX project.

please write SQL statement?
(a) Retrieve the names of employee in department 5 who work more than 10 hours per week on the ProductX project.
(b) List the names of employees who have a dependent with the same first name as themselves.
(c) Find the names of Franklin Wongs supervisor.
(d) For each project, list the project name and the total hours per week (by all employees) spent on that project.
(f) Retrieve the names of employees who do not work on any project.
(g) For each department, retrieve the department name, and the total salary of employees working in that department.
(h) Retrieve the total 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.
(j) List the last names of department managers who have dependents.
(k) Find the names of employees and the names of the projects that the employees are working on.
(l) Find the names of employees who are working on the project that is not controlled by the employees own department. (Employees who work on only the employees own departments projects).
Thank you!
EMPLOYEE B Smith 1234067B9 1960-01-09 731 Fondren, Houston, TX M 30 Franklin T Ramesh K Narayan 666824444 1902-09-1505FreOak Humbe, TXM 35000 33445500 5 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 200 IJames E Borg 688665500 193-11-10 450 Stone, Houston, TX M 50000 NULL DEPT LOCATIONS DEPARTMENT Administration 4 21 1985 0101 4 Stanford Headquarters 1 688665555 1961-06-19 5 Sugarland Houston WORKS ON PROJECT Product 1 Belaina 123456789 2 75 666884444 3 400 403453403 1 20.0 Reorganization 20 Houston 1 33440000 2 10.0 DEPENDENT Relationship 666665555 20 NULL 123456789 Elizabeth F 19 Spouse
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
