ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • Recommendations dataset 으로 실습하기
    neo4j 2025. 1. 9. 12:27

    문서

     

    실습 데이터

     

     

    Query 실습

    CALL db.schema.visualization()
    
    MATCH (g:Genre)
    RETURN g
    LIMIT 1
    
    MATCH (g:Genre)
    RETURN g.name
    
    MATCH (m:Movie)-[:IN_GENRE]->(g:Genre)
    WHERE g.name = 'Comedy'
    RETURN m.title
    
    MATCH (m:Movie)
    WHERE m.title = 'Tusk'
    RETURN m
    
    MATCH (actor:Actor)-[:ACTED_IN]->(m:Movie)
    WHERE m.title = 'Tusk'
    RETURN actor, m
    
    MATCH (p:Person{name: 'Justin Long'})-->(m:Movie)
    return p, m
    
    MATCH (:Person{name: 'Justin Long'})-->(m:Movie)
    return m.title
    
    MATCH (:Person{name: 'Justin Long'})-[:ACTED_IN]->(m:Movie)<-[r:RATED]-(u:User)
    return m.title, properties(r)
    
    MATCH (:Person{name: 'Justin Long'})-[:ACTED_IN]->(m:Movie)<-[r:RATED]-(u:User)
    return m.title As Movie, avg(r.rating) As AverageRating

    댓글

Designed by Tistory.