Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in MS SQL Server

Introduction
GROUP BY – Recap
Summary
22. Exercise 2

Instruction

Perfect! One more exercise!

Exercise

Show the sum of the TotalCost for each Department and Year, and the total sum of TotalCost for each Year. Do not show the grand total.

Show the following columns: Department, Year, and the sum of TotalCost (as Total). Instead of NULLs in the Department column, show the following text: 'unknown'.

Make sure that your table consists of the following columns: Department, Year, and Total.