Collapsing many rows into one summary row per group — counts, sums, and averages — plus the HAVING clause that filters groups.
Practice MCQs for this concept are coming soon.