9 docs tagged with "aggregation"

Use aggregate functions like SUM.

Calculate averages and extremes using SQL aggregate functions.

Use AVG and GROUP BY to calculate average transaction amount per customer.

Learn how to count rows and sum column values in SQL.

Use COUNT and GROUP BY to summarize transactions per customer.

Use GROUP BY to group rows for aggregation in SQL.

Learn how to combine JOINs and aggregate functions like COUNT and SUM.

Use DISTINCT with aggregate functions and understand nested queries.

Reflect on core SQL techniques practiced throughout the course.