Question
# b) List the names of EMPLOYEES who have no DEPENDENT # c) Find the names of EMPLOYEES that are not supervised by 'Jennifer Wallace'
# b) List the names of EMPLOYEES who have no DEPENDENT
# c) Find the names of EMPLOYEES that are not supervised by 'Jennifer Wallace'
# d) For each PROJECT, list the PROJECT name and the number of employees and the total HOURS per week
# (by all EMPLOYEES) spent on that PROJECT
# e) Retrieve the names of EMPLOYEES who work on at least two PROJECTs
# f) For each DEPARTMENT, retrieve the DEPARTMENT name, and the number of employees and the average SALARY of
# EMPLOYEES working in that DEPARTMENT
# g) Retrieve the average SALARY of all female and male EMPLOYEES
# h) Find the names of EMPLOYEES who work on at least one PROJECT located in Houston
# but whose DEPARTMENT is also in Houston.
# i) List the last names of DEPARTMENT managers who have at least one DEPENDENTs
# j) For each DEPARTMENT whose average SALARY is more than the average salary of all employees, retrieve
# the DEPARTMENT name and the number of EMPLOYEES working for that DEPARTMENT
Y SUPERSSN DNO BDATE 1965-01-09 1955-12-08 FNAME MINIT LNAME ohn Frankin T oyce Ramesh K James E Jennifer S AhmadV SSN 123456789 333445555 ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX SEX SALARY Smith Wong Eng453453453 1972-07-31 5631 Rice, Houston, TX F Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000.00 Borg Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Jabbar 987987987 1969-03-29 980 Dalas, Houston, TX M 25000.00 Zelaya 999887777 1968-01-19 3321 Caste, Spring, TX F M 30000.00 40000.00 25000.00 NULL HULL HULL 55000.00 HULL 43000.00 NULL 888665555 1937-11-10 450 Stone, Houston, TX M HULL 25000.00 NULL HULLStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started