Yurttas/PL/DBL/oracle/F/01/Company-A/q04.sql
1REM
2REM q04.sql
3REM
4REM For each project, list the project name and
5REM the total hours per week (by all employees) spent
6REM on that project.
7REM
8
9SELECT pname, SUM(hours)
10FROM Project, WorksOn
11WHERE pnumber = pno
12GROUP BY pname;