csy3024-assignment-1/scripts/queries/query9.cyp

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