Consider the following view defined on the Projects schema: CREATE VIEW EmpProject(empNo, projNo, totalHours) AS SELECT w.empNo, w.projNo, SUM(hoursWorked) FROM Employee e, Project p, WorksOn w WHERE...

Consider the following view defined on the Projects schema:

CREATE VIEW EmpProject(empNo, projNo, totalHours)

AS SELECT w.empNo, w.projNo, SUM(hoursWorked)

FROM Employee e, Project p, WorksOn w

WHERE e.empNo = w.empNo AND p.projNo = w.projNo

GROUP BY w.empNo, w.projNo;

(a) SELECT*

 FROM EmpProject;

(b) SELECT projNo

 FROM EmpProject

 WHERE projNo = ‘SCCS’;

(c) SELECT COUNT(projNo)

 FROM EmpProject

 WHERE empNo = ‘E1’;

(d) SELECT empNo, totalHours

 FROM EmpProject

 GROUP BY empNo;