How to understand this query?

This is from the tutorial: :play The "Game Of Thrones” dataset.

MATCH (c:Character)-->()
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?

Hello @lingvisa :slight_smile:

It counts the relations by node c. One tip is to use RETURN to check what you get ;)
--> represents the relation.


1 Like

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.

1 Like