I had an issue while working on the Intermediate Cypher Queries course. I was supposed to find the movie in the db with the highest number of actors and tried the following Cypher code:
MATCH (m:Movie)RETURN m.title,[(p:Person)-[:ACTED_IN]->(m) |...
I don't think there was anything wrong w/ my Cypher query (possibly the ORDER BY clause). Instead, the Cypher code they were looking for is something like:
MATCH (p:Person)-[:ACTED_IN]->(m:Movie)RETURN m.title,collect (p.name) AS actorsORDER ...