// Find all transactions between two accounts
MATCH (a1:Account)-->(t:Transaction)-->(a2:Account)
RETURN a1.id, a1.type, t.amount, t.type, a2.id, a2.type, t.is_fraud

// Find all 2-hops transaction chains
MATCH (a1:Account)-[s1:SENT]->(t1:Transaction)-[r1:RECEIVED]->
      (a2:Account)-[s2:SENT]->(t2:Transaction)-[r2:RECEIVED]->
      (a3:Account)
RETURN a1.id, a2.id, a3.id, t1.id, t1.type, t1.amount, t1.step, t1.is_fraud ,
       t2.id, t2.type, t2.amount, t2.step, t2.is_fraud 

// Find all 4-hops transaction chains
MATCH (a:Entity)-[:TRANSACTION]->(b:Entity)-[:TRANSACTION]->
      (c:Entity)-[:TRANSACTION]->(d:Entity)
RETURN a, b, c, d

// Check if there is a path between
// Notting Hill Gate and High Street Kensington stations
// in 1 hop specifically using Circle Line
MATCH (start)-[e:CONNECTED]->(end)
WHERE start.displayName = 'Notting Hill Gate'
AND e.line = 'Circle'
AND end.displayName = 'High Street Kensington'
RETURN start.displayName, e.Line, end.displayName

// Find 8-hops paths between Paddington and Blackfriars stations
MATCH (start:Station)-[e1:CONNECTED]->
      (s1:Station)-[e2:CONNECTED]->
      (s2:Station)-[e3:CONNECTED]->
      (s3:Station)-[e4:CONNECTED]->
      (s4:Station)-[e5:CONNECTED]->
      (s5:Station)-[e6:CONNECTED]->
      (s6:Station)-[e7:CONNECTED]->
      (s7:Station)-[e8:CONNECTED]->
      (end:Station)
WHERE start.displayName = 'Paddington'
AND end.displayName = 'Blackfriars'
RETURN start.displayName, start.Note, e1.Line,
       s1.displayName, s1.Note, e2.Line,
       s2.displayName, s2.Note, e3.Line, 
       s3.displayName, s3.Note, e4.Line, 
       s4.displayName, s4.Note, e5.Line, 
       s5.displayName, s5.Note, e6.Line, 
       s6.displayName, s6.Note, e7.Line, 
       s7.displayName, s7.Note, e8.Line, 
       end.displayName, end.Note

// Find all relationships involving FPGAs
MATCH (n)-[e]->(m)
WHERE n.description = 'FPGA'
RETURN n.displayName, n.description, e, m.displayName, m.description

// Find all nodes of type "EntityWithAccessionedSequence"
// and referenceType "ReferenceGeneProduct"
MATCH (n:EntityWithAccessionedSequence)
WHERE n.referenceType = 'ReferenceGeneProduct'
RETURN n.displayName, n.schemaClass, n.referenceType

// Find all patients who took Paracetamol
MATCH (p:Patient)-[:TOOK_MEDICATION]->
      (m:Medication)
WHERE m.displayName = 'Paracetamol'
RETURN p.id, p.displayName, m.displayName

// Top publications by citation count
MATCH (n:Publication)
RETURN n.displayName, n.cited_by_count
ORDER BY n.cited_by_count DESC
LIMIT 10

// Publications from a specific year using toInteger()
MATCH (n:Publication)
WHERE n.year = toInteger("2022")
RETURN n.displayName, n.year
LIMIT 10

// All executive officers of a given company
MATCH (p:Person)-[r:IS_OFFICER_OF]->(c:Company)
WHERE c.displayName = 'Air Liquide'
RETURN p.displayName, r.qualite

// All Directeur Général across CAC 40 companies
MATCH (p:Person)-[r:IS_OFFICER_OF]->(c:Company)
WHERE r.qualite = 'Directeur Général'
RETURN p.displayName, c.displayName
ORDER BY c.displayName