Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Method One
Method Two
Method Three
13. Question 3


Perfect! Here's the last question.


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!