InsideEdgeInsideEdge
Download App

Phase 3 · SQL for Data Analysis

Topics

Aggregate Functions (COUNT, SUM, AVG)

Part of the Data Analyst Roadmap.

Summary

Functions that collapse many rows into a single summary number — COUNT rows, SUM a numeric column, AVG for the mean, MIN/MAX for range — the building blocks of almost every business metric.

How to Learn This

  • 1Write queries calculating total, average, and count for a sample sales table.
  • 2Learn the difference between COUNT(*) and COUNT(column_name).
  • 3Practice combining an aggregate with a WHERE filter.

Previous

SQL Basics (SELECT, WHERE, ORDER BY)

Next

GROUP BY & HAVING

More topics in SQL for Data Analysis

SQL Basics (SELECT, WHERE, ORDER BY)GROUP BY & HAVINGJoins (INNER, LEFT, RIGHT, FULL)SubqueriesCommon Table Expressions (CTEs)Window FunctionsDate & String FunctionsQuery Optimization BasicsDatabase Design Basics (ER Diagrams)
InsideEdge

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download
InsideEdge