1. Create a table that will hold the data in avgprice kwh state.csv. This .csv 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 row that has Tennessee 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.

2. Create the tables to hold the data in Masters.csv, which contains a master list of players and their information, Teams.csv (Teams data), Batting.csv (batting statistics) and Salaries.csv (salary statistics). Load the CSV data into the tables you created, and implement the following queries:

List of top 50 players by highest number of home runs in a season. List the players by Player ID, First Name and Last Name, number of home runs and season year.

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.

Submit your CREATE TABLE statements, query statements, and results for the queries.

NOTE: Please what I need is the possible create table statements, query statement, and the step on how to do it. Do not worry on the CSV files and how to Load them. This should be in MYSQL. If you need more clarification before answering the question, please post it on the comment. Thanks.