// Neo4j Cypher: social network

// Create nodes
CREATE (avi:Person {name: "Avi Cohen", age: 32})
CREATE (dana:Person {name: "Dana Levy", age: 28})
CREATE (company:Company {name: "Wix", industry: "Tech"})

// Create relationships
CREATE (avi)-[:KNOWS {since: 2020}]->(dana)
CREATE (avi)-[:WORKS_AT {role: "Engineer", since: 2022}]->(company)
CREATE (dana)-[:WORKS_AT {role: "Designer", since: 2021}]->(company)

// Query: friends of friends (3 degrees)
MATCH (me:Person {name: "Avi Cohen"})-[:KNOWS*1..3]->(friend:Person)
RETURN friend.name, LENGTH(path) as degrees
ORDER BY degrees

// Fraud detection: find circular money transfers
MATCH path = (account:Account)-[:TRANSFER*3..6]->(account)
WHERE ALL(t IN RELATIONSHIPS(path) WHERE t.amount > 10000)
RETURN path

// Recommendation: products bought by users who bought X
MATCH (p:Product {id: 123})<-[:BOUGHT]-(user:User)-[:BOUGHT]->(rec:Product)
WHERE NOT (me:User {id: 456})-[:BOUGHT]->(rec)
RETURN rec.name, COUNT(user) as frequency
ORDER BY frequency DESC LIMIT 10

NoSQL — Document, Key-Value, Column, Graph

NoSQL — Document, Key-Value, Column, Graph

NoSQL — Document, Key-Value, Column, Graph