Lecture
This lecture covers the main aggregation functions for statistical calculations on data sets or subsets, including grouping clauses to extract statistical values per data group. It also explains how to filter group queries using HAVING queries to extract the most relevant elements. Additionally, it demonstrates how to use sorting functions with the ORDER BY keyword and limit the number of objects displayed in a result.