Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
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