How Many Actors?

Another question

Using the query you just wrote, answer this question:

Use the query you just wrote. For the largest cast, how many actors were in the movies with the title "Hamlet"?

Hint

View the results of the last query you just wrote

What is the size of the list actors who acted in a movies with a given title?

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:

cypher

MATCH (a:Actor)-[:ACTED_IN]->(m:Movie)
RETURN m.title AS movie,
collect(a.name) AS cast,
size(collect(a.name)) AS num
ORDER BY num DESC LIMIT 1

What is the size of the list for the movies with the largest cast?

Once you have entered the answer, click the Try Again button below to continue.

In this challenge, you answered another question related to the query you wrote.

In the next lesson, you will learn about working with dates and times.