Yurttas/PL/DBL/postgres/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 current_schema();
12SET search_path to "companya";
13
14SELECT pname, SUM(hours)
15FROM Project, WorksOn
16WHERE pnumber = pno
17GROUP BY pname;