Neo4j query examples

query

MATCH (b:Book)
WHERE ANY ( tag IN b.tags WHERE tag IN ['nosql','neo4j'] )
RETURN b.title,b.tags
SKIP 20
ORDER BY b.title DESC
LIMIT 20

－－－－－－－－－－－－

MATCH (b:Book)<-[r:Votes]-(:User)
OPTIONAL MATCH (b) -[p:PublishedBy]-> (c)
RETURN
  CASE p.year % 2
    WHEN 0 THEN 'Even'
    WHEN 1 THEN 'Odd'
    ELSE 'Unknown' END as parity,
  AVG(r.score)
  
－－－－－－－－－－－－

MATCH (b:Book) <-[r:Votes]- (:User)
WITH b, AVG(r.score) as avgScore
ORDER BY avgScore DESC
LIMIT 1
OPTIONAL MATCH (b) –[p:PublishedBy]-> ()
RETURN b.title, p.year

－－－－－－－－－－－－

MATCH p=shortestPath( 
   (a:User {name: "Mary", surname: "Smith"})-[*]-
       (b:User {name: "Jane", surname: "Jones"}) ) 
FOREACH (n IN tail(nodes(p)) | 
   CREATE UNIQUE (n)-[:MaybeKnows]->(a))