Here is an example Cypher query based on the movie database of Neo4J. In this Cypher, I am trying to find the number "PRODUCED" relationship for the movie title "When Harry Met Sally".
MATCH (m:Movie)-[r:PRODUCED]-() WHERE m.title ='When Harry Met Sally' RETURN COUNT(r)
You can modify this query according to your database.
MATCH (n:node_name)-[r:relationship_name]-() WHERE n.id = unique_value_for_the_node RETURN COUNT(r)