Exercise 3.2

In exercise 3.2, we have to retrieve all people who have written "other" movies, i.e movies other than one with the 'title' - Speed Racer

I'm trying something like

MATCH (p:Person)-[not :WROTE]->(:Movie {title:"Speed Racer"}) return p

but its not working. How do I get the desired result?

Hello @codeinode :slight_smile:

You have to use a WHERE clause

MATCH (p:Person)-[:WROTE]->(m:Movie)
WHERE m.title <> "Speed Racer"
RETURN DISTINCT p

Regards,
Cobra

1 Like

@cobra Thanks for the help!

1 Like