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

Introduction
Reports with revenue in categories
Summary
17. Question 2

Instruction

Very good! Let's move on to Question 2.

Exercise

For each category, find the December 2016 revenue and show it alongside the ratio of that category's revenue to the total revenue for December 2016. Show the following columns: category_name, category_revenue, and total_revenue_ratio. Round the total_revenue_ratio to 2 decimal places.

Stuck? Here's a hint!