NOTE BEFORE YOU ANSWER!!!. THIS IS A GRAPH DATABASE, SO IT IS IN Neo4j

PART 1

PART 2

upload the data in avgprice kwh-state.csv (this file is on blackboard) as nodes into neo4j. This file contains the annual data from 1990-2012 on the average energy price per kilowatt hour (KwH) by state and provider type. Implement the following queries: Print each node that has Oklahoma as state, order the result by year in descending order. Print the average residential, commercial, ndustrial, and transportation price for the state of Texas from the year 1990-2012. NOTE: You w need to use the filtering and aggregation functions from the following link https:/eo4j.com/developer/filtering-query-results/ https:/eo4j.com/developer/aggregation-returns-functions/ 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 S20 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: LabeofNode1property_of a:somefilter) MATCH (b: LabeofNode2tproperty_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' )(b) RETURN a,b You may also need to query a relationship. Here is an example: MATCH (wallstreet title: 'Wall Street' )