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)
8. List the name of the division that has more projects than division of human resource 9. List the name of employee who
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
8. List the name of the division that has more projects than division of human resource 9. List the name of employee who
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!