Aggregation

Aggregation — Is a process that involves summarizing data from multiple rows into a single result.

Is commonly done using aggregate functions. These functions are used in conjunction with the GROUP BY clause to group rows that have the same values in specified columns into summary rows. The HAVING clause is then used to filter the results based on conditions involving the aggregate functions.