Page 1 of 1

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
by answerhappygod
8 List The Name Of The Division That Has More Projects Than Division Of Human Resource 9 List The Name Of Employee Who 1
8 List The Name Of The Division That Has More Projects Than Division Of Human Resource 9 List The Name Of Employee Who 1 (11.07 KiB) Viewed 35 times
8 List The Name Of The Division That Has More Projects Than Division Of Human Resource 9 List The Name Of Employee Who 2
8 List The Name Of The Division That Has More Projects Than Division Of Human Resource 9 List The Name Of Employee Who 2 (10.52 KiB) Viewed 35 times
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)