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

Introduction
Method One
4. Method 1 – exercise 2
Method Two
Method Three
Summary

Instruction

Perfect! We have a slightly more complicated task for you next.

Exercise

Calculate the total revenue generated (after discount) by customers from France and by customers from other countries. Show two columns: customer_country (either 'France' or 'Other') and discount_revenue. Round the second column to two decimal places.

Stuck? Here's a hint!

In the inner query, join the orders and customers table. Use the country column to find out if a customer is from France. In the outer query, join the CTE with order_items to calculate the sum for each order. Use the ROUND(column, 2) function.