Yurttas/PL/DBL/oracle/F/01/Company-A/q04.sql
Jump to navigation
Jump to search
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;