8. List the name of the division that has more projects than division of human resource 9. List the name of employee who
Posted: Sun May 15, 2022 7:58 am
8. List the name of the division that has more projects than division of human resource 9. List the name of employee who only works on project the with chin (use NOT EXISTS). | 10. Using update statement to increase the salary of a manager by 10% if he/she works on more than 1 projects sponsored by other division.
Division (DID, dname, managerID) Employee (emplD, name, salary, DID) Project (PID, pname, budget, DID) Workon (PID, EmplD, hours)
Division (DID, dname, managerID) Employee (emplD, name, salary, DID) Project (PID, pname, budget, DID) Workon (PID, EmplD, hours)