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
Method One
Method Two
Method Three
Summary
13. Question 3

Instruction

Perfect! Here's the last question.

Exercise

Create a report to show the percentage of total revenue after discount generated by orders with low (less than or equal to 90.0) and high (greater than 90.0) freight values in each country we ship to.

Show the following columns: ShipCountry, PercentageLowFreight, and PercentageHighFreight.

Round the percentages to the nearest integer using ROUND(x, 0) function. Then cast them to integer type.

Stuck? Here's a hint!