Difference between revisions of "Yurttas/PL/DBL/mssql/F/01/Company-A/q04.sql"
Jump to navigation
Jump to search
(Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">/* REM REM q04.sql REM REM For each project, list the project name and REM the total hours per week (by all employees)...") |
(No difference)
|
Latest revision as of 04:28, 3 November 2013
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;