Aggregations and WITH

WITH = '|' for Cypher

WITH separates the query into stages. Anything you want to use after a WITH must be explicitly listed in the WITH — variables not listed go out of scope.

Aggregations (count, collect, sum, avg, min, max) implicitly group by the non-aggregated keys in the same RETURN/WITH — the same rule as SQL without writing GROUP BY.