Skip to content

Instantly share code, notes, and snippets.

@vladbatushkov
Last active August 1, 2019 18:08
Show Gist options
  • Save vladbatushkov/f666c496bc73dd3ece10072bdaec3bf3 to your computer and use it in GitHub Desktop.
Save vladbatushkov/f666c496bc73dd3ece10072bdaec3bf3 to your computer and use it in GitHub Desktop.
Day in February with lowest number of calls.
// How to use NOT: https://neo4j.com/docs/cypher-manual/current/clauses/where/#filter-on-patterns-using-not
MATCH (c:Call)
WHERE c.from.month = 2
RETURN date(c.from), count(c) as calls
ORDER BY calls
LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment