Advanced Cypher Queries

Building on the basics, this lesson covers advanced Cypher features including aggregation, UNWIND, CASE expressions, subqueries, variable-length paths, and WITH for query pipelining.

Aggregation Functions

Cypher provides built-in aggregation functions:

Function	Description	Example
`count()`	Count results	`count(p)`
`sum()`	Sum numeric values	`sum(o.total)`
`avg()`	Average	`avg(p.age)`
`min()`	Minimum value	`min(p.age)`
`max()`	Maximum value	`max(p.age)`
`collect()`	Collect values into a list	`collect(p.name)`
`percentileCont()`	Percentile (continuous)	`percentileCont(p.age, 0.5)`
`stDev()`	Standard deviation	`stDev(p.age)`

Counting

// Count all Person nodes
MATCH (p:Person)
RETURN count(p) AS totalPeople

// Count purchases per person
MATCH (p:Person)-[:PURCHASED]->(product:Product)
RETURN p.name, count(product) AS purchaseCount
ORDER BY purchaseCount DESC

Collecting into lists

// Collect all product names purchased by each person
MATCH (p:Person)-[:PURCHASED]->(product:Product)
RETURN p.name, collect(product.name) AS products

WITH — Query Pipelining

The WITH clause passes results from one part of a query to the next, enabling multi-step queries:

Advanced Cypher Queries

Advanced Cypher Queries

Aggregation Functions

Counting

Collecting into lists

WITH — Query Pipelining

More in Database