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

GROUP BY Extensions in SQL

Introduction
Summary
15. Exercise 1

Instruction

For this quiz, we’ll be using a small table named customer_order. The following columns are available: id, country, customer, customization, and total_price. You can use the button on the right side to analyze this table’s contents before we start.

Exercise

Find the average total price in all grouping combinations made from the following columns: country, customer, and customization.

Show the following columns in the query result: country, customer, customization, and avg_price.