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 PostgreSQL

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: ship_country, percentage_low_freight, and percentage_high_freight.

Round the percentages to two decimal places.

Stuck? Here's a hint!