LOAD CSV WITH HEADERS FROM 'https://gist.githubusercontent.com/davidoliverSP2/716ed3b7155efbe78b5bd41d4c3c523a/raw/bcba24649549b58f44563766cba39bdb8ba2931b/draft_data.csv' AS line
MERGE (:Round {id: line.Round})
MERGE (:DraftPosition {id: line.`Draft Position`})
MERGE (:Team {name: line.Team})
MERGE (:Player {name: line.Player})
MERGE (:Position {name: line.Position})
MERGE (:College {name: line.College})
MERGE (: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