---
# System prepended metadata

title: Untitled

---

## emoji ratio

couldn't figure out the case clause, so you'll have to divde
```
MATCH (u:User {id:id})-[:CREATED]->(s:Signal)
MATCH (u1:User)-[x:REACTED_TO]->(s)
MATCH (u)-[xx:REACTED_TO]->(s1:Signal)
WHERE NOT (u)-[:CREATED]->(s1)
WITH 
    COUNT(DISTINCT(x)) AS reactions_received,
    COUNT(DISTINCT(xx)) AS reactions_given
return
    {
        reactions_received: reactions_received, 
        reactions_given: reactions_given
    
    }```