MATCH (t:Troll)-[:POSTED]->(:Tweet)-[:CONTAINS_ENTITY]->(l:Location)
RETURN l.name AS name, COUNT(DISTINCT t) AS num ORDER BY num DESC LIMIT 10

MATCH (:Tweet)-[:MENTIONS]->(t:Troll)
RETURN t.name AS name, COUNT(*) AS num ORDER BY num DESC LIMIT 10

MATCH (u:User)-[:POSTED]->(:Tweet)-[:MENTIONS]->(t:Troll)
RETURN t.name AS name, COUNT(DISTINCT u) AS num ORDER BY num DESC LIMIT 10

MATCH (t:Tweet) WHERE t.created_str > "2014-07" and t.created_str < "2017-09"
RETURN substring(t.created_str,0,7) AS day,
  COUNT(t) AS num ORDER BY day

MATCH (u:User)-[:POSTED]->(t:Tweet) WHERE u.location = "USA" and EXISTS(t.created_at)
RETURN  substring(t.created_str,11,2) AS hour,
    COUNT(t) AS num ORDER BY hour

MATCH (trump:User),(clinton:User),
p = shortestPath((trump)-[*..15]-(clinton))
WHERE trump.screen_name = "realdonaldtrump" AND clinton.screen_name = "hillaryclinton"
RETURN p

MATCH (t:Tweet) WHERE t.created_str > "2014-07" and t.created_str < "2017-09"
RETURN substring(t.created_str,0,7) AS day,
  COUNT(t) AS num ORDER BY day

MATCH (u:User)-[:POSTED]->(t:Tweet) WHERE u.location = "USA" and EXISTS(t.created_at)
RETURN  substring(t.created_str,11,2) AS hour,
	COUNT(t) AS num ORDER BY hour

MATCH (a:Troll)-[:POSTED]->(:Tweet)-[:RETWEETED]->(:Tweet)<-[:POSTED]-(b:Troll)
WHERE a<>b
MERGE (a)-[r:CITES]->(b)
RETURN count(r)

CALL algo.labelPropagation("MATCH (t:Troll) RETURN id(t) AS id","MATCH (r1:Troll)-[:POSTED]->(t:Tweet)<-[:RETWEETED]-(:Tweet)<-[:POSTED]-(r2:Troll) RETURN id(r2) AS source, id(r1) AS target, COUNT(t) AS weight","OUTGOING",   {graph:'cypher', write: true, iterations: 200})

START n=node(*)
MATCH (n)-[r:CITES]->(x)
DELETE r

MATCH (u:User)-[:POSTED]->(t:Tweet)
WHERE t.text contains 'conspiracy'
RETURN u.screen_name, count(u) as paranoia_number ORDER BY paranoia_number DESC