SET PAGESIZE 50000
SET MARKUP HTML ON TABLE "class=detail cellspacing=0" ENTMAP OFF
          
--Format the columns
COLUMN employee_name HEADING "<p class=left>Employee Name</p>" FORMAT A40
COLUMN project_name HEADING "<p class=left>Project Name</p>" FORMAT A40
COLUMN hours_logged HEADING "<p class=right>Hours</p>" FORMAT 9,999
COLUMN dollars_charged HEADING "<p class=right>Dollars</p>" -
       FORMAT $999,999.99

--Turn off feedback and set TERMOUT off to prevent the
--report being scrolled to the screen.
SET FEEDBACK OFF
SET TERMOUT OFF
     
--Execute the query to generate the report.
SPOOL middle.html
SELECT e.employee_name,
       p.project_name,
       SUM(ph.hours_logged) hours_logged,
       SUM(ph.dollars_charged) dollars_charged
FROM employee e INNER JOIN project_hours ph
     ON e.employee_id = ph.employee_id
     INNER JOIN project p 
     ON p.project_id = ph.project_id
GROUP BY e.employee_id, e.employee_name,
          p.project_id, p.project_name;
SPOOL OFF
EXIT