6. Retrieve the department_id, sum salaries in these departments (10,40, 60, 80). _ 7. Retrieve the first characters of the first name for each-employees as capital letters. 8. Retrieve the department_id, sum-salary of the departments (40,50,60,70) that employs more than 5 employees 9. Retrieve the employee name and dependent name of al employees. 10. Retrieve the sum of salaries of the managers of all departments 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. LNAME Smith Wong EMPLOYEE FNAME MINIT John B Frandin T Alicia J Jennifer S Ramesh K Joyce Ahmad V James E SSN 123456789 333445555 990687777 987654321 666884144 453453453 987987987 889805555 Zelaya Watce Narayan BDATE 1965-01.09 1955-12-08 1968-07-19 1041-06-20 1962-09-15 1972-07-31 1969-03-29 1937-11-10 ADDRESS 731 Fonden Houston, TX 638 Voss, Houston, TX 3321 Casti Song TX 291 Bony. Bofare, TX 975 Fire Oak, Humble, TX 5631 Rio, Houston, TX 980 Dalas, Houston, TX 450 Stone, Houston, TX ss SEX SALARY M 30000 M 40000 F 25000 F 43000 M 38000 F 25000 M 25000 M 53000 SUPERSSN ONO 335566 5 888806555 5 987654321 4 888666555 333445555 5 333445555 5 987654321 4 nu 1 Jabbar Borg Compsit riner DEPT LOCATIONS DNUMBER LOCATION 1 Houston 4 Sutford MGRSTARTDATE 5 Belaire 1988-06-22 5 Sugarland 1995-01-01 5 Houston 1981-05-19 DEPARTMENT DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445555 987654321 888605555 WORKS ON PROJECT DNUM ESSN 123456789 123456789 666884444 453453453 4535253 333445555 333445555 000155 333445555 999887777 999887777 987987567 987987987 987654321 987654321 888665555 ANO HOURS 1 325 2. 7.5 3 40.0 1 200 2 20.0 2 100 3 100 100 20 100 30 30.0 10 100 10 35.0 30 30 30 20.0 20 150 20 nud PNAME Products Product Product2 Computation Rogation Newbenefits PNUMBER 1 2 3 10 20 PLOCATION Beli Sugarland Houston Stafford Houston Salord 5 5 5 4 1 4 88888 DEPENDENT SEX F M F ESSN 33344555S 333445555 333645555 SE254321 123456789 123456789 123456789 DEPENDENT NAME Alice Theodore Joy Abner Miche Alce Elbeth BOATE 1985-04-15 1983-1025 1958-05-13 1912-02-28 1968.01.04 1988.120 19670516 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE M M F F