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.