Query for the co authors problem in CY neo4j

[GiannisStasinak]

Hi everyone ! I have to write a query about collaboration between authors for my homework. My nodes are "authors" and "articles". I have connected articles and authors as ( ()-[:composedby]->()) and authors between them the same way. I want to write a query so to find the top 5 authors with most distinct collaborations but this one didn't work :
</>
MATCH (a:Author)-[:WORKSWITH]->(b:Author) MATCH (article:Article)-[:COMPOSEDBY]->(a:Author) RETURN a.name AS Name, COUNT(b) AS Collaboration ORDER BY Collaboration DESC LIMIT 5
</>
Any ideas with that ? I wrote COUNT( DISTINCT b) but still no result.

[ameyasoft]

GiannisStasinakis82:

MATCH (a:Author)-[:WORKSWITH]->(b:Author) MATCH (article:Article)-[:COMPOSEDBY]->(a:Author) RETURN a.name AS Name, COUNT(b) AS Collaboration ORDER BY Collaboration DESC LIMIT 5

Try this:
MATCH (article:Article)-[:COMPOSEDBY]->(a:Author) 
MATCH (a)-[:WORKSWITH]->(b.Author) 
RETURN a.name AS Name, COUNT(distinct b.name) AS Collaboration 
ORDER BY Collaboration DESC LIMIT 5