$(2)$ Payment for hours not worked. $($Hint: compare hours in the transactions file to the time file,

Steps: summarize payroll transactions and time records for the month, join the monthly payroll

to the monthly time on employee number and filter to test if regular and overtime hours in

transaction file equal hours in time file, This one requires a nested query$)$

Here is the query output to help you:. create sql statement to get this table