MATCH (a:Player)<-[r:Rel_A|Rel_B|Rel_C]-(b:Team) WHERE a.keyNo = "keyNo" AND a.keyNo <> b.keyNo RETURN b, a.keyNo as fromKeyNo, a.name as fromName, collect(r.role), collect(type(r)), count(b.keyNo) order by count(b.keyNo) desc
(root@nebula) [ProdRelation]> go from 815677140545765099 OVER Employ, Invest, Legal Reversely yield $$.Person.keyno as keyno, $$.Person.name as name, $^.Company.keyno as src, $^.Company.name as srcName, Employ.role as eRole, Invest.role as iRole, Legal.role as lRole | group by $-.keyno yield $-.keyno, count(*) as nameCnt, $-.srcName | order by $-.nameCnt desc
[ERROR (-12)]: SemanticError: Yield non-agg expression `$-.srcName' must be functionally dependent on items in GROUP BY clause