This is from the tutorial: :play https://guides.neo4j.com/got/01_eda.html. The "Game Of Thrones” dataset.
WITH c, count(*) AS num
RETURN min(num) AS min, max(num) AS max, avg(num) AS avg_characters, stdev(num) AS stdev
'-->': What does this do?
'num': Are arrays of what?
It counts the relations by node
c. One tip is to use
RETURN to check what you get ;)
--> represents the relation.
A bit more context,
--> is shorthand for
-->, so this is MATCHing on paths of a :Character node with a relationship (of any type) to any kind of node, then per character getting a count of rows. As a result per row we have each character and the number of relationships for that character (so
num isn't an array, it's just an integer count, and we have a separate count per row/character). Then we apply aggregations over that count.