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

Revenue Trend Analysis in SQL Server

Introduction
Reports with revenue in categories
Summary

Instruction

Well done! It's time for an additional exercise.

Exercise

Create a report of the category revenue for orders shipped to Germany. Show three columns: CategoryName, CategoryRevenue, and TotalRevenueRatio. The last column should show the ratio of category revenue to total revenue generated by orders shipped to Germany.

Stuck? Here's a hint!

Create a temporary table using:

WITH AllCategories AS (
  SELECT SUM(Amount) AS TotalSum
  FROM Orders
  WHERE ShipCountry = 'Germany'
)

Calculate the last column as:

SUM(OI.Amount) / CAST(AC.TotalSum AS decimal(10,2)) AS TotalRevenueRatio