Checking for Null Values

How many movies have no poster?

Write and execute a query to return the titles of all movies that do not have a poster.

Once you executed, enter the number of rows returned below and click Check Answer.

  • ✓ 149

Hint

To better understand the names of the properties of Movie nodes, you can retrieve a small set of them and observe the names of the properties using table view of the results returned.

A property for a node that does not exist has a null value.

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 (m:Movie)
WHERE
m.poster IS NULL
RETURN m.title

How many rows does it return?

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

Summary

In this challenge, you wrote and executed a query to test if a property does not exist.

In the next challenge, you will answer another question about the graph.