Question: Create nodes from the data in Teams.csv (Teams data) and Salaries.csv (salary statistics). Implement the following queries: List average salaries for each team in 2012.
Create nodes from the data in Teams.csv (Teams data) and Salaries.csv (salary statistics). Implement the following queries: List average salaries for each team in 2012. List the teams by Team ID, League ID, Team Name, and average salary amount in descending order. Count how many player each team had in the 2012 season. List the teams by Team ID, League ID, Team Name, count of player in descending order. Create e graph showing the players that are paid more than $20 millions in the 2012 season. Display the graph by showing the players node and the teams that they played for in 2012. NOTE: You may need to create relationship. Relationship are created in the from MATCH (a:LabeofNode1{property_of_a:somefilter}) MATCH (b:LabeofNode2{property_of_b:somefilter}) WHERE a.name = "nameofnode1" AND b.name = " nameofnode2" CREATE (a)-[: Relation]->(b) RETURN a,b You may also need to query a relationship. Here is an example: MATCH (wallstreet { title: Wall Street })<-[:ACTED_IN|:DIRECTED]-(person) RETURN person.name More example of how to query a relationship can be found here https:// neo4j.com/docs/cypher-manual/current/clauses/match/ Submit your load statements, Create relation ship statements, query statements, and results for the queries.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
