Counting results
Most active director?
Using count() write a query to return the number of movies a person directed.
What is the highest number of movies a director directed in our graph?
-
✓ 42
Hint
You will need to order the count results so you can determine the highest count.
Solution
You can run the following query to find the answer:
cypher
MATCH (d:Director)-[:DIRECTED]-(m)
RETURN d.name AS Director,
count(*) AS numMovies
ORDER BY numMovies DESC LIMIT 5What number is the highest for a director?
Once you have entered the answer, click the Try Again button below to continue.
Summary
In this challenge, you wrote a query to aggregate results so you could answer a question about the data.
In the next challenge, you will write a query to create lists.