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 (pl)-[:TO]->(tm)
CREATE (pl)-[:FROM]->(cl)
CREATE (pl)-[:PICKED_IN]->(rd)
CREATE (pl)-[:PLAYED_IN]->(cn)
CREATE (College)-[:PLAYS_IN]->(cn)
CREATE (Team)-[:SELECTION]->(rd)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