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 MS SQL Server

Introduction
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.