#enter the graph
USE GRAPH financialGraph

# create a query
CREATE OR REPLACE QUERY q5a() SYNTAX v3 {

  //find close pairs that has distance less than 0.8
  SELECT a, b,  gds.vector.distance(b.emb1, a.emb1, "COSINE") AS dist INTO T
  FROM (a:Account)-[e:transfer]->()-[e2:transfer]->(b:Account)
  WHERE gds.vector.distance(a.emb1, b.emb1, "COSINE") < 0.8;

  PRINT T;
}

#compile and install the query as a stored procedure
install query q5a

#run the query
run query q5a()