Graph-Based Movie Recommender

MATCH (n) RETURN labels(n)[0] AS label, count(*) AS count
ORDER BY count DESC
UNION ALL
MATCH ()-[r]->() RETURN type(r) AS label, count(*) AS count

MATCH (u:User)-[r:RATED]->(:Movie)
RETURN u.userId AS userId, u.name AS name, count(r) AS ratingsGiven, round(avg(r.rating),2) AS avgRating
ORDER BY ratingsGiven DESC LIMIT 5

MATCH (m:Movie)<-[r:RATED]-(:User)
RETURN m.movieId AS movieId, m.title AS title, count(r) AS numRatings, round(avg(r.rating),2) AS avgUserRating, m.avgRating AS avgRating
ORDER BY numRatings DESC LIMIT 10

MATCH ()-[r:RATED]->() RETURN r.rating AS rating, count(*) AS count ORDER BY rating

MATCH (m:Movie)-[:IN_GENRE]->(g:Genre)
OPTIONAL MATCH (m)<-[r:RATED]-()
RETURN g.name AS genre, count(DISTINCT m) AS movieCount, count(r) AS totalRatings, round(avg(r.rating),2) AS avgRating
ORDER BY movieCount DESC

MATCH (m:Movie)-[:DIRECTED_BY]->(d:Director)
OPTIONAL MATCH (m)<-[r:RATED]-()
RETURN d.name AS director, count(DISTINCT m) AS movieCount, round(avg(r.rating),2) AS avgUserRating
ORDER BY movieCount DESC

MATCH (m:Movie)<-[r:RATED]-(:User)
WITH m, count(r) AS numRatings, avg(r.rating) AS avgUserRating, stDev(r.rating) AS stDev
WHERE numRatings >= 3
RETURN m.movieId AS movieId, m.title AS title, numRatings, round(avgUserRating,2) AS avgUserRating, round(stDev,2) AS stDev
ORDER BY stDev DESC LIMIT 10

MATCH (u1:User)-[:RATED]->(m:Movie)<-[:RATED]-(u2:User)
WHERE u1.userId < u2.userId
WITH u1, u2, count(m) AS coRated, avg(abs((u1)-[:RATED]->(m)).rating - ((u2)-[:RATED]->(m)).rating) AS avgAbsDiff
RETURN u1.userId AS user1, u2.userId AS user2, coRated, round(avgAbsDiff,2) AS avgAbsDiff
ORDER BY coRated DESC LIMIT 10

MATCH (u:User)-[r:RATED]->(m:Movie)-[:IN_GENRE]->(g:Genre)
WITH u, g, avg(r.rating) AS avgRating, count(*) AS ratingsInGenre
ORDER BY avgRating DESC
WITH u, collect({genre:g.name, avgRating:avgRating, ratingsInGenre:ratingsInGenre})[0] AS top
RETURN u.userId AS userId, u.name AS name, top.genre AS topGenre, round(top.avgRating,2) AS avgRating, top.ratingsInGenre AS ratingsInGenre