Hi there !
the following query:
match (n)-[:friend*0..3]->(b) where n.salary >= 19999 and n.address="Paris" and b.salary >= 19999 and b.address="Paris" return distinct n.name order by n.name
doesn't give me what I want:
I'm trying to display all the names of the persons living in Paris for whom all of their friends for 3 level generations also live in Paris and also have a salary higher than 19999.
The above query doesn't do it well, what am I doing wrong ?
for example: if Buddy lives in Paris, earns +20k and all of his friends for 3 level generations also live in Paris and earn +20k then Buddy should be returned. Else he shouldn't be.