in mysql

we SOL Code add be done in War IM NL Autonha 2. Keber. Sed 480*1953022360 New Belle TX, MOOD 85 LOYEE Marta et Product PONT 5. Delete the time 6 Delete the PROJECT NAME 7. Modify the MORSSN and MGESTARTDAT fibe DEPARTMENT NUMURS 123456789 and 1999-10-01.pectively 8. Modify the SUPERSSN tribute of the EMPLOYEE uple wa SSNITT 13 Mars] 9. Retrieve all employees whose address is in Houston Texas Maria 10. Find all employees who were bor during the 195 11. Show the resulting salaries if every employee working on the ProductZpwet 10 percent [6 Marks 12. Retrieve the name of each employee who works on all the project cooled by department mumber [6 Marks 13. Retrieve the names of employees who have no dependents 15 Marts 14. For each project on which more than two employees work, retrieve the project number, the pjename, the number of employees who work on the project 15 Marts 15. For each department that has more than five employees retrieve the department number and the number of in employees who are making more than $40,000 16. Add an attribute for keeping track of jobs of employees to the empleryee table WORS ON 1216 NO 1 25 1 2 2 1 10 20 10 10 10 10 200 2010 100 100 10.0 100 100 100 250 907654321 200 15.0 null 20 20 SSSS PROJECT PNAME Product Produkty Product Computertation Reorganization Newbenefit ENUMERPLOCATION DNUM 1 Belaire 5 2 Sufland 5 a Houston 5 10 Stafford 4 20 Houston 30 Stafford DEPENDENT ESSN DEPENDENT NAME 333445555 Alice 333445555 Theodore 333445555 Soy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elabeth SEX BDATE F 1986-04-05 M 1983-10-25 F 1958-05-03 M 1942-02-28 M 1988-01-04 F 1988-12-30 F 1957-05-05 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE UNIVERSITY OF THE COMMONWEALTH CARIEREAN UCC SCHOOL OF TECHNOLOGY & MATHEMATICS Department of adormation Technology DATABASE MANAGEMENT SYSTEMS INDIVIDUAL ASSIGNMENT 2200 COMPANY DATABASE SA SOL EMPLOYEE DNO FNAME MINIT NAME Smith Frankin T Wang Alida 1 Jennifer 5 Wate Ramesh Narayan Joyce A English Ahmad v Labbar James E DATE ADORES 1234567 1963-11-09 731 Fonde Houston, TA 513445556 1955 12-SV, Houston, TX 1968 1-ES 121 Cinte Spring, $1476543211941-06-20 291 Berry Belle TX 6668846441962.09-15 975 Fire Oak Harbie TX 453451453 1972-07-31 5631 Rice, Houston, TX 987987987190903 190 Dallas, Houston, TX 388665555 1937.11-10 450 Stone Houston, TX M M F F M F SALARY SUPERSEN JOGOO 2331153 40000555 25000 96765421 43000 B65555 38000 313445555 25000 131445555 5 4 4 5 5 4 1 ent M M 25000 7654321 55000 DEPARTMENT DNAME Research Administration Headquarters DNUMBER MGRSSN MGRTARTDATE 5333445555 1988-OS 22 49876543211965-01-01 11665555 1981-06-19 DEPT_LOCATIONS DNUMBER DLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland Houston we SOL Code add be done in War IM NL Autonha 2. Keber. Sed 480*1953022360 New Belle TX, MOOD 85 LOYEE Marta et Product PONT 5. Delete the time 6 Delete the PROJECT NAME 7. Modify the MORSSN and MGESTARTDAT fibe DEPARTMENT NUMURS 123456789 and 1999-10-01.pectively 8. Modify the SUPERSSN tribute of the EMPLOYEE uple wa SSNITT 13 Mars] 9. Retrieve all employees whose address is in Houston Texas Maria 10. Find all employees who were bor during the 195 11. Show the resulting salaries if every employee working on the ProductZpwet 10 percent [6 Marks 12. Retrieve the name of each employee who works on all the project cooled by department mumber [6 Marks 13. Retrieve the names of employees who have no dependents 15 Marts 14. For each project on which more than two employees work, retrieve the project number, the pjename, the number of employees who work on the project 15 Marts 15. For each department that has more than five employees retrieve the department number and the number of in employees who are making more than $40,000 16. Add an attribute for keeping track of jobs of employees to the empleryee table WORS ON 1216 NO 1 25 1 2 2 1 10 20 10 10 10 10 200 2010 100 100 10.0 100 100 100 250 907654321 200 15.0 null 20 20 SSSS PROJECT PNAME Product Produkty Product Computertation Reorganization Newbenefit ENUMERPLOCATION DNUM 1 Belaire 5 2 Sufland 5 a Houston 5 10 Stafford 4 20 Houston 30 Stafford DEPENDENT ESSN DEPENDENT NAME 333445555 Alice 333445555 Theodore 333445555 Soy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elabeth SEX BDATE F 1986-04-05 M 1983-10-25 F 1958-05-03 M 1942-02-28 M 1988-01-04 F 1988-12-30 F 1957-05-05 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE UNIVERSITY OF THE COMMONWEALTH CARIEREAN UCC SCHOOL OF TECHNOLOGY & MATHEMATICS Department of adormation Technology DATABASE MANAGEMENT SYSTEMS INDIVIDUAL ASSIGNMENT 2200 COMPANY DATABASE SA SOL EMPLOYEE DNO FNAME MINIT NAME Smith Frankin T Wang Alida 1 Jennifer 5 Wate Ramesh Narayan Joyce A English Ahmad v Labbar James E DATE ADORES 1234567 1963-11-09 731 Fonde Houston, TA 513445556 1955 12-SV, Houston, TX 1968 1-ES 121 Cinte Spring, $1476543211941-06-20 291 Berry Belle TX 6668846441962.09-15 975 Fire Oak Harbie TX 453451453 1972-07-31 5631 Rice, Houston, TX 987987987190903 190 Dallas, Houston, TX 388665555 1937.11-10 450 Stone Houston, TX M M F F M F SALARY SUPERSEN JOGOO 2331153 40000555 25000 96765421 43000 B65555 38000 313445555 25000 131445555 5 4 4 5 5 4 1 ent M M 25000 7654321 55000 DEPARTMENT DNAME Research Administration Headquarters DNUMBER MGRSSN MGRTARTDATE 5333445555 1988-OS 22 49876543211965-01-01 11665555 1981-06-19 DEPT_LOCATIONS DNUMBER DLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland Houston