Beginner

79. GROUP BY with Multiple Aggregates

Learn how to calculate multiple aggregate metrics for each group in a single SQL query.

📘 Lesson 79 of 728 ⏱ 9 min 🎯 Beginner

A GROUP BY query can contain multiple aggregate functions. This allows analysts to calculate several metrics, such as count, total, average, minimum, and maximum, for each group.

Business reports usually require more than one metric. Combining multiple aggregates in one query makes analysis more efficient and provides a complete view of each group.

A sales manager may need transaction count, total sales, average sales, minimum sale, and maximum sale for every region.

SQL 
SELECT
    Region,
    COUNT(*) AS Transactions,
    SUM(SalesAmount) AS TotalSales,
    AVG(SalesAmount) AS AverageSale,
    MIN(SalesAmount) AS MinimumSale,
    MAX(SalesAmount) AS MaximumSale
FROM Sales
GROUP BY Region;

This technique is widely used in MIS reporting, sales dashboards, financial analysis, regional performance reports, and management reporting.

  • Multiple aggregate functions can be used together.
  • Each aggregate is calculated for every group.
  • COUNT, SUM, AVG, MIN, and MAX can be combined.
  • This creates detailed summary reports.
  • Aliases make aggregate results easier to understand.
Can multiple aggregate functions be used with GROUP BY?

Yes. Multiple aggregate functions can calculate different metrics for each group.

Why use multiple aggregates in one query?

It provides several business metrics for each group without requiring separate queries.

Have you finished this lesson?

Introduction to SQL – All Lessons