Possible to limit returned result after group by

[joruxs]

Suppose we have this structure with Person vertices and properties for their favorite drinks:

CREATE TAG Person (name string, drink int);

Given that we have this data...

vid Person.name Person.drink
--- ------------ ------------
1   steve        coca cola
2   sara         coca cola
3   daniel       coca cola
4   anna         pepsi
5   donna        pepsi
6   paul         7-up

...it seems you can lists all occurring drinks and how many fans they each have respectively by doing:

match (p:Person) return p.Person.drink as drink, count(*) as num_of_fans;
+-----------+-------------+
| drink     | num_of_fans |
+-----------+-------------+
| coca cola | 3           |
| pepsi     | 2           |
| 7-up      | 1           |
+-----------+-------------+

This is fine but I would like to limit the result to only list drink which have (num_of_fans > 1 and num_of_fans < 3) so only pepsi would be listed. It is like I want to add a second WHERE clause after the return. How can I achieve this?

[joruxs]

I believe I found a solution.

In the open cypher documentation (https://s3.amazonaws.com/artifacts.opencypher.org/openCypher9.pdf) in the section about WITH there is an example called "Filter on aggregate function results":

Adapting their example to my problem above we can do this:

MATCH (p:Person)
WITH p.Person.drink as drink, count(*) as num_of_fans
WHERE num_of_fans > 1 AND num_of_fans < 3
RETURN drink, num_of_fans;