Yurttas/PL/DBL/oracle/F/01/Company-A/q04.sql

From ZCubes Wiki
Revision as of 22:54, 4 November 2013 by MassBot1 (talk | contribs) (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) s...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/Company-A/q04.sql&oldid=79111"