1.  List the name of each manager, his/her salary,  his/her divisional average salary, and total number of projects he/she works on      

2.  List the name of the division that has more people working on  'Wed Development" than ' DB development' .

3.  List the name of the employee that has the highest salary in his/her division and list the total number of projects he/she does not work on. 

4. List the name of employee who ONLY works with Grace on some project(s). (Hint, this employee E works on a project Grace also works on and there NOT EXISTS a project Grace does not work on but E works on) .

5. For each division, show its name and the "emp_project" rate, which is the percentage of employees working on project in that division.  (e,.g, if a division has 5 employees and 4 of them working on some project(s), then the rate is 80%)

 

Division (DID, dname, managerID) 

Employee (empID, name, salary, DID)

 Project (PID, pname, budget, DID)

 Work on (PID, EmpID, hours)