【Neo4j】Using WHERE to Filter Queries

Question 1

Suppose you want to add a WHERE clause at the end of this statement to filter the results retrieved.

MATCH (p:Person)-[rel]->(m:Movie)<-[:PRODUCED]-(:Person)

What variables, can you test in the WHERE clause?

Select the correct answers.

•  p
•  rel
•  m
•  PRODUCED

Question 2

Suppose you want to retrieve all movies that have a released property value that is 2000, 2002, 2004, 2006, or 2008. Here is an incomplete Cypher example to return the title property values of all movies released in these years. What keyword do you specify for XX?

MATCH (m:Movie)

WHERE m.released XX [2000, 2002, 2004, 2006, 2008]

RETURN m.title

Select the correct answer.

•  CONTAINS
•  IN
•  IS
•  EQUALS

Question 3

We want a query that returns the names of any people who both acted in and wrote the same movie. What query will retrieve this data?

Select the correct answer.

•  MATCH (p:Person) WHERE (p)-[:WROTE]-(m) AND (p)-[:ACTED_IN]-(m) RETURN p.name, m.title
•  MATCH (p:Person)-[:ACTED_IN]→(m:Movie) WHERE (p)-[:WROTE]-(m) RETURN p.name, m.title
•  MATCH (p:Person)-[:ACTED_IN | WROTE]→(m:Movie) RETURN p.name, m.title
•  MATCH (p:Person)-[:ACTED_IN]→(m:Movie)←[WROTE]-(p) RETURN p.name, m.title