This preview shows page 1. Sign up to view the full content.
Unformatted text preview: those hours worked. The results of running that query are shown in Figure P7.22. SELECT SUM(ASSIGN_HOURS), SUM(ASSIGN_CHARGE), EMP_LNAME, EMP_NUM FROM ASSIGNMENT ORDER BY EMP_LNAME 23. Write a query to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The output is shown in Figure P7.23. SELECT SUM(ASSIGN_HOURS), SUM(ASSIGN_CHARGE), PROJ_NUM FROM ASSIGNMENT ORDER BY PROJ_NUM 24. Write the SQL code to generate the total hours worked and the total charged made by all employees. The results are shown in Figure P7.24. SELECT SUM(ASSIGN_HOURS), SUM(ASSIGN_CHARGE) FROM ASSIGNMENT...
View Full Document
This note was uploaded on 07/13/2011 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.
- Summer '08