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

Creating Basic SQL Reports in SQL Server

Introduction
Providing detailed information and counting objects
Calculating metrics for multiple business objects
8. Products in stock per category
Understanding the difference between various count metrics
Summary

Instruction

Good job! Let's try another exercise using computations for multiple objects.

Exercise

How much are the products in stock in each category worth? Show three columns: CategoryID, CategoryName, and CategoryTotalValue. You'll calculate the third column as the sum of unit prices multiplied by the number of units in stock for all products in the given category.

Stuck? Here's a hint!

Calculate the third column as:

SUM(UnitPrice * UnitsInStock) AS CategoryTotalValue