neo4j/cypher: Combining COUNT and COLLECT in one query by Mark Needham.
From the post:
In my continued playing around with football data I wanted to write a cypher query against neo4j which would show me which teams had missed the most penalties this season and who missed them.
Mark discovers queries with two aggregation expressions have problems but goes on to solve it as well.