Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
CUBE
Summary
17. Exercise 1

## Instruction

For this quiz, we’ll be using a small table named CustomerOrder. The following columns are available: Id, Country, Customer, Customization, and TotalPrice. 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: GroupingId (depending on Country, Customer, and Customization), Country, Customer, Customization, and AvgPrice.