Skip to content

Instantly share code, notes, and snippets.

@vladbatushkov

vladbatushkov/Top_10_from_Bangkok.cypher

Created August 18, 2019 09:30
Show Gist options
  • Save vladbatushkov/03a2b91336f25d80fcda51b7f77cec97 to your computer and use it in GitHub Desktop.
Save vladbatushkov/03a2b91336f25d80fcda51b7f77cec97 to your computer and use it in GitHub Desktop.
Download ZIP
Top 10 persons with highest number of calls from Bangkok
Raw
Top_10_from_Bangkok.cypher
MATCH (c:City { name: "Bangkok" })<-[:FROM]-(p1:Person)-[:OUT]->(cc:Call)<-[:IN]-(p2:Person)
RETURN p1.name, count(cc) as total
ORDER BY total DESC
LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment