Suggest an editImprove this articleRefine the answer for “What is data aggregation in SQL?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)Data aggregation in SQL is **combining a set of rows into one summary value** using **aggregate functions**: `COUNT()` counts rows, `SUM()` totals values, `AVG()` computes an average, and `MIN()`/`MAX()` find the minimum and maximum. **Key point:** the example `SELECT department, AVG(salary) FROM employees GROUP BY department` groups employees by department and computes the average salary in each.Shown above the full answer for quick recall.Answer (EN)ImageData aggregation in SQL is **combining a set of rows into one summary value** using **aggregate functions**. These functions count, total, or average data across groups. ### Examples of aggregate functions - `COUNT()`, counts the number of rows, - `SUM()`, totals values, - `AVG()`, computes the average, - `MIN()` / `MAX()`, find the minimum and maximum. ### Example ```sql SELECT department, AVG(salary) FROM employees GROUP BY department; ``` This query **groups employees by department** and **computes the average salary** in each department.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.