Due: 13th Oct 98.
1. List all employees who have dependents born after 01-01-1070. (under age)
2. List the name and ssn of all employees who work for managers whose start date is after May 4, 1990
3. List the name and salary of all employees who have more than 3 dependents
4. List all employees names that have at least one dependent and they are not working in more than one project.
5. List all dependent birthdates of all employees working on project number 10 whose address is Mills Ave. and have the maximun hours working in that project number.
6. List the name of the dependents whose birthday is in the month of October for all the employees that work on department location X.
7. List the department name and project name where the project is located in El Paso and where the maximum people working in that same department are greater than the females working in all projects.
8. List all project names where the project manager's salary < maximum salary of the employees working on the project.
9. Find the names of the managers of departments where none of the employees works on all the projects controlled by any single department.
10. List the names of all the employees who have more sons than daughters as their dependents
11. List all of the departments where the lowest paid male makes more than = the highest paid female.
12. List the male dependent names of all empoyees whose average hours working in his/her projects is more than 32.
13. List the department name and department location where the averge salary in that department is greater then others.
14. Which manager would have to buy an authentic New York Yankee's jersey (because the plant is right accross the street) for their employee's son who was born on 9/4/82?
15. List the names and bithdates by department name of the of all the employees and employee's dependents who work on a project located in El Paso.
16. List the project name, location, and manager's name of the controlling = department for every project that has more females than males working on = it.
17. List name of all employees who only work on project 1 or 2 but not both, and their spouses are working in the same company but not on the same project or same department.
18. list the names of the managers whos salary is more than the maximal salary of that dept.and have more than 2 depentdents.
19. List the names of all employees who are married to another company employee and whose combined salary (as a couple) is greater than the average salary of all employees.
20. List the managers and corresponding department names who's oldest dependent is older than any of the dependents of their subordinates.
21. List all the departments that have more female employees then male employees.
22. List the name of all non-managers who only have daughters as dependents.
23. Find out the names of employees who on the project number 3 and whose salary is lower than the average salary of the department he or she works for.
24. List all the social security numbers of employess who do not have any dependents.