Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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.