Skip to article frontmatterSkip to article content
Site not loading correctly?

This may be due to an incorrect BASE_URL configuration. See the MyST Documentation for reference.

SLOs

Aggregating Data

Week 06: April 20–24

At the end of this week, you should be able to:

  1. Count rows and non-NULL values using COUNT.

  2. Use DISTINCT inside aggregate functions to count unique values.

  3. Apply numeric aggregate functions — SUM, AVG, MIN, and MAX — to summarize data.

  4. Group query results by one or more columns using GROUP BY.

  5. Write aggregate queries that span multiple joined tables.

  6. Filter grouped results using a HAVING clause and explain how it differs from WHERE.

  7. Simplify complex queries by defining Common Table Expressions (CTEs) with WITH.

Week 05
Homework 3
Week 07
SLOs