Question

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, industrial, and transportation price for the state of Texas from the year 1990-2012. NOTE: You will need to use the filtering and aggregation functions from the following link https://neo4j.com/developer/filtering-query-results/ https://neo4j.com/developer/aggregation-returns-functions/

Answer 1

Solution:

--------------------------------------------------------------------------------------------------------------------------------------------