ployee 001 002 003 004 005 006 007 Location YYZ YVR YOW YOW YYZ YEG YYZ Department Salary 50000 45000 40000 45000 50000 60000

Question

ployee 001 002 003 004 005 006 007 Location YYZ YVR YOW YOW YYZ YEG YYZ Department Salary 50000 45000 40000 45000 50000 60000 50000 HR IT HR MKTG IT SALES MKTG Using the table shown above write a query to find the total salary for all location department combos Note The Final table should also contain subtotals for each

Kunduz · Accepted Answer

Click to see the answer