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 PostgreSQL

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

Instruction

Hello! Welcome to the next part of our course. This time, we'll be talking about multi-level aggregation – i.e., reports in which we first calculate a metric and then find the average value of that metric.

Our reports will answer questions like:

  • What is the average order value?
  • What is the average number of items in a single order for various shipping countries?

All such questions require us to perform multi-level aggregation. Sound complicated? Don't worry, we'll go through everything step by step!

Exercise

Click Next exercise to continue.