Because your "a" nodes can be either actors or movies. As you don't use labels or a direction, the pattern applies in both directions.
The movies of course don't have a "name" property. Try to use this (added labels and direction): match (a:Person)-[:ACTED_IN]->(m:Movie) return a.name, count(*) as mcount order by mcount desc limit 5 > Am 17.05.2017 um 13:33 schrieb Akshay Kadidal <[email protected]>: > > hi This query is showing null count as 172. Not sure why I am getting nuls. > > this is the standard movie database on neo4j without any changes. > > > match (a)-[:ACTED_IN]-(m) return a.name, count(*) as mcount order by mcount > desc limit 5 > > thank you, > Akshay > > > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
