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 introduces the logics of aggregation queries and sorting of the result in Geographic Information Systems. It covers aggregation functions like SUM, COUNT, AVG, MIN, and MAX, as well as the GROUP BY and HAVING clauses. The instructor demonstrates how to write aggregation queries, sort query results, and limit the number of records returned.