Queries to analyse the political contributions

Contributions analysis.cql

//-----------------------
//Company whose employees donated the more money
//-----------------------

MATCH (a:COMPANY)<-[:IS_EMPLOYED]-(b:INDIVIDUAL)-[r:HAS_CONTRIBUTED]->(c:COMMITTEE)
RETURN a.EMPLOYER, SUM(r.TRANSACTION_AMT) as total
ORDER BY total DESC
LIMIT 10

//-----------------------
//Who people from PWC donated money to?
//-----------------------
MATCH (a:COMPANY)<-[:IS_EMPLOYED]-(b:INDIVIDUAL)-[HAS_CONTRIBUTED]->(c:COMMITTEE)-[r:HAS_CONTRIBUTED]->(d:CANDIDATE)
WHERE a.EMPLOYER='PWC'
RETURN d.CAND_NAME as Candidate, SUM(r.TRANSACTION_AMT) as total
ORDER BY total DESC
LIMIT 10

//-----------------------
//Richest committee
//-----------------------
MATCH (a:INDIVIDUAL)-[r:HAS_CONTRIBUTED]->(b:COMMITTEE)
RETURN b.CMTE_NM as PAC, SUM(r.TRANSACTION_AMT) as total
ORDER BY total DESC
LIMIT 10

//-----------------------
//Richest candidate
//-----------------------
MATCH (a:COMMITTEE)-[r:HAS_CONTRIBUTED]->(b:CANDIDATE)
RETURN b.CAND_NAME as Candidate, SUM(r.TRANSACTION_AMT) as total
ORDER BY total DESC
LIMIT 10

//-----------------------
//Candidate counts per party
//-----------------------
MATCH (a:CANDIDATE)-[AFFILIATED_TO]->(b:PARTY)
RETURN b.PARTY_NAME, count(a) as candidate_count
ORDER BY candidate_count  DESC
LIMIT 10

//-----------------------
//Unfaithfull committees
//-----------------------
MATCH (a:COMMITTEE)-[HAS_CONTRIBUTED]->(b:CANDIDATE)
RETURN a.CMTE_NM, count(b) as count
ORDER BY count  DESC
LIMIT 10

//-----------------------
//Total individual contributions
//-----------------------
MATCH (a:INDIVIDUAL)-[r:HAS_CONTRIBUTED]->(b:COMMITTEE)
RETURN SUM(r.TRANSACTION_AMT) as total