Multiple Aggregates

How can we calculate several statistics in one query?

Intermediate⏱ 3 Minutes⭐ 800 XP

🤔 THE QUESTION

How can we calculate several statistics in one query?

💡 WHAT IS IT?

Multiple aggregate functions can be executed simultaneously in a single SELECT statement to generate comprehensive summary reports.

🎯 WHAT IS IT USED FOR?

Summary cards, KPI dashboards, statistical overviews in single-pass query scans.

💻 EXAMPLE

SELECT
COUNT(*) AS employee_count,
MIN(salary) AS minimum_salary,
MAX(salary) AS maximum_salary,
AVG(salary) AS average_salary
FROM employees;

Practice typing production-grade SQL code for Multiple Aggregates.