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;