LOAD CSV WITH HEADERS FROM 'https://gist.githubusercontent.com/davidoliverSP2/716ed3b7155efbe78b5bd41d4c3c523a/raw/bcba24649549b58f44563766cba39bdb8ba2931b/draft_data.csv' AS line
CREATE (:Player {name: line.Player, draftposition: toInt(line.`Draft Position`)})
CREATE (:Round {id: toInt(line.Round)})
CREATE (:Team {name: line.Team})
CREATE (:Player {name: line.Player})
CREATE (:Position {name: line.Position})
CREATE (:College {name: line.College})
CREATE (:Conference {name: line.Conference})

CREATE (Player)-[:POSITION_IS]->(Position)
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 frequency

MATCH path=(a:Person {name: 'Alice'})-[:FRIENDS_WITH]-(:Person)-[:FRIENDS_WITH]-(fof:Person)
RETURN path, a, fof