Yurttas/PL/DBL/mssql/F/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
11SELECT pname, SUM(hours)
12FROM Project, WorksOn
13WHERE pnumber = pno
14GROUP BY pname;