6.6 Aggregation and Sorting with PGQL

Like SQL, PGQL has support for the following:

• GROUP BY to create groups of solutions

• MIN, MAX, SUM, and AVG aggregations

• ORDER BY to sort results

And for many other familiar SQL constructs.

For GROUP BY and aggregation, see the relevant section of the PGQL specification here. For ORDER BY, see the relevant section of the PGQL specification here.