This lecture covers the main aggregation functions for statistical calculations on data sets, including grouping clauses to extract statistical values by data group and sorting functions using the ORDER BY keyword, along with limiting the number of objects in the result.