# 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 HULL