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

Creating Basic SQL Reports in SQL Server

Introduction
Basic multi-level aggregation
4. Multi-level aggregation – step 1
Multi-level aggregation in groups
Multi-level aggregation with custom classification
Three or more aggregation levels
Summary

Instruction

Good! Now we'll show you how to write your own multi-level aggregation query. As we said earlier, we'll go step by step. Let's start with finding the average number of items in each order.

In step one, we'll count the items in each query.

Exercise

Create a simple query (no CTE needed) that will show two columns: OrderID and ItemCount. The ItemCount column should show the sum of quantities of all items in a given order.

Stuck? Here's a hint!

Use the OrderItems table. Group by OrderID and use SUM(Quantity).