Which movie has the most number of actors in it? Which pair of actors have acted together in most number of movies?
Here's what i tried
MATCH (actor:Person)-[:ACTED_IN]-(movie:Movie)
RETURN movie.name
I expect the movie name with a count of the number of actors in the movie
This will give you pairs of actors who have acted together in most number of movies. There are a lot of ties since 7 pairs have acted in 3 movies.
We get the max number of movies the actors acted together (3 movies). Then again get the pair of actors where they acted in 3 movies.
It should be easy enough for you to do the other question about;