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


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.


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.