simple double match
MATCH (p:Professor)<-[:STUDENT_OF]-(s:Student)
WITH p, avg(s.grade) as grade
MATCH (p:Professor)<-[:STUDENT_OF]-(s:Student)
WHERE s.grade > grade
RETURN p,collect(s) as students
better collect + filter
MATCH (p:Professor)<-[:STUDENT_OF]-(s:Student)
WITH p, avg(s.grade) as gr
Hi,
I am new to Neo4j and Cypher. I want to write a query for getting following
information:
*Graph Description:* Sample graph schema image is attached in this post
with properties of each node. Graph contains Professor nodes (labeled with
P) and student nodes (labeled with S). Professor nod
