这里有两种选择。
再次匹配并查找具有最大收入的演员：

match (a:Person)-[role:ACTED_IN]->(m:Movie)
with m, max(role.earnings) as earnings
match (a:Person)-[:ACTED_IN{earnings:earnings]->(m)
return m.title as Movie, earnings, a.name as actor

排序并选取集合中的第一项：

match (a:Person)-[role:ACTED_IN]->(m:Movie)
with m, role.earnings as earnings, a.name as actor order by earnings
return m.title as Movie, collect(earnings)[0] as earnings, collect(actor)[0] as actor

需要考虑的其他一些问题：

• 如果两个参与者的收入相同，您希望如何处理？
• 一个演员是否可以在同一部电影中扮演多个角色/根据ACTED_IN关系获得收入？

你可以按收入降序对电影、收入和演员进行排序/收集。然后获取集合中的第一项。

MATCH (a:Person)-[role:ACTED_IN]->(m:Movie)
WITH m, role.earnings as earnings, a ORDER BY earnings DESC
RETURN m.title as Movie, collect(earnings)[0] as earnings, collect(a.name)[0] as actor