neo4j cypher - Match node where another specific node of the same type doesn't exist

Question

Background

I have a neo4j database set up with the following nodes;

(:game)-[:teamscore]-(:team)

The 'game' node would contain an id, a date and a name

The 'team' node link would contain an id, a teamname and an score.

Desired Outcome

I am looking to match nodes where teamname = "TeamA" but only where there isn't a linked node that exists with a different team for that 'game'.

(in plain English)

I want to return all nodes relating to a game where only 'TeamA' has scored (and not conceded).

What I have so far

MATCH(g:game)-[:teamscore]-(t:team)
WHERE g.team = "TeamA"
RETURN g, t

I thought about adding some kind of NOT (g)-[:teamscore]-(:team) to the WHERE clause but I'm not sure how I could do this in a way which doesn't eliminate the node which I do want to match.

Thanks in advance for any help on this!

Answer 1

You can a match team by name and then make sure only one team is linked to that game by specifying the number of teamscore relationships to that game is 1.

MATCH(g:game)-[:teamscore]-(t:team) 
WHERE t.teamname = "TeamA" AND size((g)-[:teamscore]-(:team))=1 
RETURN g, t