REPLACEME: Introductory text and domain model image.
This domain model diagram was created with the Arrows tool
LOAD CSV WITH HEADERS FROM 'https://gist.githubusercontent.com/davidoliverSP2/716ed3b7155efbe78b5bd41d4c3c523a/raw/bcba24649549b58f44563766cba39bdb8ba2931b/draft_data.csv' AS line
MERGE (pl:Player {name: line.Player, draftposition: toInt(line.`Draft Position`)})
//MERGE (rd:Round {id: toInt(line.Round)})
//MERGE (tm:Team {name: line.Team})
MERGE (ps:Position {name: line.Position})
//MERGE (cl:College {name: line.College})
//MERGE (cn:Conference {name: line.Conference})
CREATE (pl)-[:POSITION_IS]->(ps);
//CREATE (Player)-[:TO]->(Team)
//CREATE (Player)-[:FROM]->(College)
//CREATE (Player)-[:PICKED_IN]->(Round)
//CREATE (Player)-[:PLAYED_IN]->(Conference)
//CREATE (College)-[:PLAYS_IN]->(Conference)
//CREATE (Team)-[:SELECTION]->(Round)MATCH (a:Person {name: 'Alice'})-[:FRIENDS_WITH]-(:Person)-[:FRIENDS_WITH]-(fof:Person)
RETURN fof.name as fof, count(*) as frequencyMATCH path=(a:Person {name: 'Alice'})-[:FRIENDS_WITH]-(:Person)-[:FRIENDS_WITH]-(fof:Person)
RETURN path, a, fof