1. Retrieve the name and address of all employees who works for the research department. 2. Retrieve the names of employees who works on all the project controlled by department number 5. 3. Retrieve the names of employees who have no dependents 4. Retrieve the sum of salaries and number of employees in each department. 5. Retrieve the maximum and minimum salary for each department 6. Retrieve the department_id, sum salaries in these departments (10, 40, 60, 80). SQ 7. Retrieve the amala yoses.capitartetters al 8. Retrieve the department_id, sum salary of the departments 40,50 employees employs more than 5 9. Retrieve the employee name and dependent name of al employees. 10. Retrieve the same sollici parmest 11. Retrieve the employee_id, salary and department_id of the employees who work in the department that has the maximum number of employees, The COMPANY database schema. SSN GOOD EMPLOYEE FNAME MINIT John B Frandin T Alicia J Jennifer S Ramesh K Joyce Ahmad v James E LNAME Smith Wong Zelaya Wie Narayan English Jabber Borg 333445555 999887777 987654321 866884144 453453453 987987987 BOATE 1965-01:00 1955-12-08 1953-07-19 1941-05-20 1982-00-15 1972-07-31 1900-03-29 1937-11-10 ADDRESS Fonden Houston 608 Voss Houston, TX 3321 Cast Spring TX 291 Bery, Belaire, TX 975 Fire Oak. Humble, TX 5631 Ribe Houston, TX 980 Dales, Houston, TX 450 Stone, Houston, TX SEX SALARY M 30000 M F 25000 F 43000 M 38000 F 25000 M 25000 M 55000 SUPERSSN ONO 5 BSS 5 987954321 4 BES & 330445555 5 3334655 5 587654321 4 nu 1 Sommer DEPARTMENT Primerke DEPT LOCATIONS DNUMBER 1 4 MGRSTARTDATE 5 1988-05-22 5 1985-01-01 5 1981-05-19 DNAME Rocoach Administration Headquarters DNUMBER 5 4 1 DLOCATION Houston Studio Bel Sugand Houston MGRSSN 383445855 987654321 888805555 WORKS ON PNO 1 2 3 3 2 2 3 PROJECT DNUM ESSN 123456789 123456789 656884444 453453453 453453453 333445665 333445555 2014 333445555 999887777 890887777 987987937 987987967 987654321 987654321 888055556 HOURS 32.5 75 40.0 200 200 1010 1010 100 100 30.0 100 350 5.0 20.0 15.0 nu PNAME Product Product Produck Computation Flamantation Nebenles PNUMBER 1 2 3 10 20 PLOCATION Beim Sugarland Houston Suford Houston Sword 5 5 5 4 3 4 BB 8888 20 20 DEPENDENT SEX ESSN 333143655 333445555 333445555 987654321 12345679 123456789 123456789 DEPENDENT NAME Alice Theodore Joy Abner Michael Aloe Elraben F M F M M F F BOATE Der L5 1983-1035 1958-650 1942.00 19880104 1988-1290 1967-05-06 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE