6 lines
194 B
Plaintext
6 lines
194 B
Plaintext
|
//Which teams had the most draws
|
||
|
|
MATCH (t:Team)-[:PLAYED_IN {result: "Drew"}]->(m:Match)
|
||
|
|
WITH t, count(m) AS drawn_matches
|
||
|
|
ORDER BY drawn_matches DESC
|
||
|
|
RETURN t.name as most_draws, drawn_matches
|