I amvery new with cypher and i have the knowledge about the basic queries. But recently i came across the given CQL while reading an artice on Recommendation Systems in Northwind Database. Please refer to Query 23 in this article: Article
Can someone explain the query step by step so that it is easy for me to understand? Any help is greatly appreciated. Thank you.
WITH 1 as neighbours
WHERE me.customerID = 'ANTON' and NOT ( (me)-[:RATED|PRODUCT|ORDER*1..2]->(p:Product) )
WITH p, COLLECT(r.rating)[0..neighbours] as ratings, collect(c.companyName)[0..neighbours] as customers
WITH p, customers, REDUCE(s=0,i in ratings | s+i) / size(ratings) as recommendation
ORDER BY recommendation DESC
RETURN p.productName, customers, recommendation LIMIT 10