An aggregate act in SQL is the process of applying aggregate functions to grouped data subsets from a data table. To accomplish this, aggregate functions, such as COUNT, SUM, AVG, MIN, and MAX, are combined with the GROUP BY clause to calculate specific groups of data. As a result of these actions, SQL provides valuable insights for data analysis and decision-making by extracting meaningful summaries and statistical information.