6 Using Data Assignment Table Write Sql Code Yield Total Number Hours Worked Employee Tota Q37091544

6. Using the data in the ASSIGNMENT table, write the SQLcode that will yield the total number of hours worked for eachemployee and the total charges stemming from those hours worked,sorted by employee number. The results of running that query areshown in Figure P7.6.

We were unable to transcribe this imageFIGURE P7.6 TOTAL HOURS AND CHARGES BY EMPLOYEE EMP NUM EMP LNAME SumOfASSIGN HOURS SumOfASSIGN CHARGE 387.50 1664.65 1218.70 1382.50 840.15 192.85 3.1 19.7 11.9

OR

 

OR