Summary
In this chapter, we looked at building queries while applying filters. We have taken a look at filtering the data using node labels and relationship types, using relationship directions, the performance impact of using node labels when compared to relationship types for traversal, using WHERE clauses, WITH clauses, SKIP clauses, LIMIT clauses, and EXISTS clauses, and using regular expressions.
We looked at sorting the data using the ORDER BY clause with one value or multiple values in ascending order or in descending order and combining the ORDER BY clause with the WITH clause.
Finally, we looked at aggregating results using the COUNT, COLLECT, MIN, MAX, and AVG functions. Along with this, we also looked at combining the COUNT and COLLECT functions to perform some complex aggregations.
In the next chapter, we will take a look at using LIST expressions, working with the UNION clause. We will also take a look at using sub-queries using the CALL clause.
