1. Create a table that will hold the data in avgprice kwh state.csv. This .csv file...
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.
Homework Answers
Add Answer to:
1. Create a table that will hold the data in avgprice kwh
state.csv. This .csv file...
PLEASE NOTE BEFORE YOU ANSWER. THIS IS NOT MYSQL, IT IS MONGODB. IF YOU DO NOT...
PLEASE NOTE BEFORE YOU ANSWER. THIS IS NOT MYSQL, IT IS MONGODB. IF YOU DO NOT KNOW MANGODB, PLEASE DO NOT ANSWER THIS QUESTION. LEAVE IT FOR SOMEONE WHO KNOWS IT. PART 1 Create a collection that will hold the data in avgprice kwh state.json. This .json 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: 1. Print each document that has Oklahoma as...
Create the database and tables for the database. Show all SQL statements. Include primary and foreign...
Create the database and tables
for the database. Show all SQL statements. Include primary and
foreign keys. Insert data into each table. Show select statements
and display the output of each table. Note:Student’s name must be
inserted into table as part of the data! Perform the SQL below:
Query one table and use WHERE to filter the results. The SELECT
clause should have a column list, not an asterisk (*). State the
purpose of the query; show the query and...
Create a class to hold data about a high school sports team. The Team class holds...
Create a class to hold data about a high school sports team. The Team class holds data fields for high school name (such as Roosevelt High), sport (such as Girls’ Basketball), and team name (such as Dolphins). Include a constructor that takes parameters for each field, and include get methods that return the values of the fields. Also include a public final static String named MOTTO and initialize it to Sportsmanship!. Create a class named Game. Include two Team fields...
Q.1] Write SQL statements based on the tennis database schema (practice homework 5) Get all the different tow...
Q.1] Write SQL statements based on the tennis database schema (practice homework 5) Get all the different town names from the PLAYERS table. 2. For each town, find the number of players. 3. For each team, get the team number, the number of matches that has been played 'for that team, and the total number of sets won. 4. For each team that is captained by a player resident in "Eltham", get the team number and the number of matches...
Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based...
Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: • Each Job is for a specific customer and there can be more than one job per customer. • The name and address must be tracked for each customer. • Each job is described by up to 2000 characters. • Each job has a status of ‘open, ‘in process’, or ‘complete’. • Each job has a start date and end...
java Part 1 Create a NetBeans project that asks for a file name. The file should...
java Part 1 Create a NetBeans project that asks for a file name. The file should contain an unknown quantity of double numeric values with each number on its own line. There should be no empty lines. Open the file and read the numbers. Print the sum, average, and the count of the numbers. Be sure to label the outputs very clearly. Read the file values as Strings and use Double.parseDouble() to convert them. Part 2 Create a NetBeans project...
Use MS Access software to build tables, as well as write, and execute queries. Submit the...
Use MS Access software to build tables, as well as write, and execute queries. Submit the database and screenshots of all tables and queries. Step by step snapshots included. Don't want queries. Just process of creating this data step by step in Access. Create your own data. Ensure the data will test all criteria and prove all sorts worked as required. Be sure that all tables and queries have descriptive names. “Query 1” and “Step 1” are examples of poor...
Using the following data to create various queries below. Database is Pensacola Healthcare Facility(FacilityID, SuborgID, Addr)...
Using the following data to create various queries below. Database is Pensacola Healthcare Facility(FacilityID, SuborgID, Addr) Provider(ProviderID, FirstName, LastName, NPI, FacilityID) Patient(PatientID, FirstName, LastName, Addr) Appointment (AppointmentID, ApptTime, ProviderID, PatientID, FacilityID) 1. Write a query displaying all patients 2. Write a query showing all appointments for a patient with an ID of 2. 3. Write a query in DESC order of Addr for all facilities. 4. Write a query showing all Providers with name LIKE Smith. 5. Write a query...
The assignment requires reading and understanding the data model used by Cassandra and representing a given ER model with Cassandra “tables”. The decision of which tables to define is driven by the qu...
The assignment requires reading and understanding the data model
used by Cassandra and representing a given ER model with Cassandra
“tables”. The decision of which tables to define is driven by the
queries that need to be answered. A software company is interested
in developing a Video Sharing application. They have designed a
conceptual model of the data they need to handle in order to offer
users these main functions:
1. The creation of channels where they can upload videos....
0. Modify or create the table(file) named Staff first used in assignment 5. There is no...
0. Modify or create the table(file) named Staff first used in assignment 5. There is no change to the structure, and if you need to recreate it the column names, data types and lengths are described below: Table Name Column Name Data Type Length Comment/constraint Staff: id int name varchar office char fee decimal reviewDate date 3 primary key 15 not null 7 7,2 default 0.00 Initials have been added to the name column values, so data for an insert...
Create the database and tables
for the database. Show all SQL statements. Include primary and
foreign keys. Insert data into each table. Show select statements
and display the output of each table. Note:Student’s name must be
inserted into table as part of the data! Perform the SQL below:
Query one table and use WHERE to filter the results. The SELECT
clause should have a column list, not an asterisk (*). State the
purpose of the query; show the query and...
Q.1] Write SQL statements based on the tennis database schema (practice homework 5) Get all the different town names from the PLAYERS table. 2. For each town, find the number of players. 3. For each team, get the team number, the number of matches that has been played 'for that team, and the total number of sets won. 4. For each team that is captained by a player resident in "Eltham", get the team number and the number of matches...
The assignment requires reading and understanding the data model
used by Cassandra and representing a given ER model with Cassandra
“tables”. The decision of which tables to define is driven by the
queries that need to be answered. A software company is interested
in developing a Video Sharing application. They have designed a
conceptual model of the data they need to handle in order to offer
users these main functions:
1. The creation of channels where they can upload videos....
0. Modify or create the table(file) named Staff first used in assignment 5. There is no change to the structure, and if you need to recreate it the column names, data types and lengths are described below: Table Name Column Name Data Type Length Comment/constraint Staff: id int name varchar office char fee decimal reviewDate date 3 primary key 15 not null 7 7,2 default 0.00 Initials have been added to the name column values, so data for an insert...
Most questions answered within 3 hours.
-
3.
Potential legal issues or claims of limiting qualified
applicants from applying can best be avoided...
asked 6 minutes ago -
(Part 1)If cash decreases by $10,000 during the year, accounts
receivable increases by $5,000, and liabilities...
asked 1 hour ago -
Michelle is attending college and has a part-time job. Once she
finishes college, Michelle would like...
asked 2 hours ago -
Per Saylor, what date was the first mutual fund
thought to have been founded?
asked 3 hours ago -
In a random sample of 7 residents of the state of Maine, the
mean waste recycled...
asked 4 hours ago -
Let's say you have a perfectly circular road around a point. A
car is driving on...
asked 5 hours ago -
a. Why is it important for a central bank to be independent.
Describe at least two...
asked 5 hours ago -
Two capacitors, C1 = 29.0 µF and
C2 = 3.00 µF, are connected in parallel and...
asked 5 hours ago -
Describe any ethics considerations you think
you should keep in mind while developing and
sharing your...
asked 5 hours ago -
The operations manager of a large production plant would like to
estimate the mean amount of...
asked 5 hours ago -
Who is responsible for the evaluating the process of the
strategic plan and the operational plan?...
asked 5 hours ago -
% Ionization using Henderson Hasselbalch equation ionization
given ph and pka:
pka:8.0
at a pH of...
asked 5 hours ago