Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
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.