Yurttas/PL/DBL/mysql-f-2010/01/Company-A/q04.sql

 1/*
 2REM
 3REM q04.sql
 4REM
 5REM For each project, list the project name and
 6REM the total hours per week (by all employees) spent
 7REM on that project.
 8REM
 9*/
10
11\. set-db.sql
12
13SELECT pname, SUM(hours)
14FROM Project, WorksOn
15WHERE pnumber = pno
16GROUP BY pname;