Add a subquery
Top French movie
Here is your starter code:
MATCH (g:Genre)
// write subquery
RETURN g.name AS genre, numMovies
ORDER BY numMovies DESCWrite and execute the subquery to return the movie nodes that have a countries list element of 'France'.
-
You must pass in the g variable to the subquery.
-
You must test if the movie node for that genre was released in France.
-
The subquery must return the count of the movie nodes, numMovies for each Genre passed in.
How many movies were in the largest Genre category for movies released in France? (enter a number)
-
✓ 277
Hint
Use WITH to pass in the Genre reference.
The subquery will find all movies of that Genre released in France. It will return the count of the movies.
How many movies were in the largest Genre category for movies released in France? (enter a number)
Once you have entered the answer, click the Try Again button below to continue.
Solution
You can run the following query to find the answer:
MATCH (g:Genre)
CALL { WITH g
MATCH (g)<-[:IN_GENRE]-(m) WHERE 'France' IN m.countries
RETURN count(m) AS numMovies
}
RETURN g.name AS Genre, numMovies ORDER BY numMovies DESCHow many movies were in the largest Genre category for movies released in France? (enter a number)
Once you have entered the answer, click the Try Again button below to continue.
Summary
In this challenge, you answered a question by writing a Cypher subquery.
In the next challenge you will write a query to combine results.