1. Retrieve the number of female employees in the company. 2. Retrieve the average salary, minimum and maximum salary of the male employees. 3. For each employee, list his/her name along with the project names he/she is working on. 4. For each project, list its name and controlling department name. 5. For each project, list its name, the controlling department name, and controlling department manager name. 6. Retrieve the names of employees who work on the project "ProjectX". 7. Retrieve the first name and last name of the male employee who has the highest salary. 8. Retrieve the first names and last names of the employees who DON'T work on any projects. 9. Retrieve the names and SSNs of employees who more than one dependent. 10. For each employee, list his/her name along with his/her department manager name.

WORKS ON PROJECT PnumberPlocation Dnum Bellaire Pno Hours ProductX ProductY Productz 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 10 35.0 5.0 20.0 20 15.0 2 Sugarland5 3 10 Stafford Houston Newbenefits Stafford 10 DEPENDENT 20 ndent name xBdate Relationship 333445555 333445555 Theodore 333445555 Joy 98765432 Abner 123456789Michael 123456789 Alice 23456789 Elizabeth 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 Alice 10 30 20 NULL F 1967-05-05 Spouse Given a company database schemas as below: EMPLOYEE _Fname Minit Lname Ssn Bdate Address Sex Salary Super ssn Dno DEPARTMENT Dname Dnumber Mgr ssn Mgr start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Figure 3.7 Referential integrity constraints displayed on the COMPANY relational database schema. DEPENDENT Essn Dependent_nameSexBdate Relationshi