I'm just getting familiar with Neo4j/Cypher and have been playing with the provided example graphs in the browser.
How can I return pairs of actors and their common movies when they have acted in at least two movies together?
The graph for this seems to look OK ...
match (p1:Person)-[:ACTED_IN]->(m1:Movie)<-[:ACTED_IN]-(p2:Person)-[:ACTED_IN]->(m2:Movie)<-[:ACTED_IN]-(p1) return p1,m1,m2,p2
... but I see duplication in the text result.
I'd be very interested to see alternative solutions with comments on how path uniqueness plays a role and comments on their relative merit/performance.