Write an SQL line that uses the following information: Results to select: lastName, personnel.empID as ID, sum(timesheet.hourworked)
Fantastic news! We've Found the answer you've been seeking!
Question:
Write an SQL line that uses the following information: Results to select: lastName, personnel.empID as ID, sum(timesheet.hourworked) as total Tables to search: personnel, timesheet Ensure ID's are the same using the where clause Use "Group by" to group employees for the SUM Alter the heading of the results table to be appropriate for new results.
a. What code should I have to query using the above information?
b. What code should I have for each table row to print the correct result in each column (lastName, ID, total)?
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: