Introduction
Providing detailed information and counting objects
Calculating metrics for multiple business objects
Understanding the difference between various count metrics
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: category_id, category_name, and category_total_value. 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(unit_price * units_in_stock) AS category_total_value
