gistfile1.txt

= Relationships

[source,cypher]
----
CREATE (umu:UNIVERSITY {name:"Ume Universitet"})
CREATE (mat:DEPARTMENT {name:"Matematik"})
CREATE (fv:COURSE {name:"flervariabel analys"})
CREATE (roland:PERSON {name:"Roland"})
CREATE (anna:PERSON {name:"Anna"})
CREATE (wille:PERSON {name:"William"})
CREATE (anna)-[:DAUGHTER]->(roland)
CREATE (wille)-[:SON]->(anna)
CREATE (roland)-[:TOOK {year:1977}]->(fv)
CREATE (wille)-[:TOOK {year:2012}]->(fv)
CREATE (fv)<-[:PROVIDED_BY]-(mat)
CREATE (mat)-[:BELONGS_TO]->(umu)
----

//graph

[source,cypher]
----
MATCH (p2)-[:DAUGHTER|SON*2]->(p1:PERSON)-[t1:TOOK]->(class:COURSE)<-[:PROVIDED_BY]-(dpt:DEPARTMENT)-[:BELONGS_TO]->(umu:UNIVERSITY),
(p2)-[t2:TOOK]-(class) 
RETURN p1, p2, class, abs(t1.year-t2.year) as diff
----

//table