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...
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...
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...
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...
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...
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...
Could someone please help me write this in Python? If time allows, it you could include...
Could someone please help me write this in Python? If time
allows, it you could include comments for your logic that would be
of great help.
This problem involves writing a program to analyze historical win-loss data for a single season of Division I NCAA women's basketball teams and compute from this the win ratio for each team as well as the conference(s) with the highest average win ratio. Background Whether it's football, basketball, lacrosse, or any other number of...
Deliverable 1. Simple SQL Statements Caution: Read the instructions carefully! Each question is based on a...
Deliverable 1. Simple SQL Statements Caution: Read the instructions carefully! Each question is based on a single SQL statement, and the single SQL statement might contain sub-queries (additional SELECT statements) within the statement. Provide a list all of the Customer ID, Customer Names, and States and sort the list in alphabetical order by Customer Name. Provide a list of all of the Customer ID, Customer Names, and States, and sort the list by state with the Customer Names in alphabetical...
SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address...
SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address has been denormalized to include City and State for performance reasons. DeptNbr is a foreign key that references DeptNbr in the Department table Manager is a foreign key that references EmployeeID in the Employees table Data Structure: (EmployeeId, LastName, FirstName, Street, City, State, Zip, DateOfHire, DateOfBirth, JobTitle, Salary, DeptNbr(fk), Manager(fk)) TABLE: Department Business Rules: DeptNbr is defined as the primary key. Data Structure: (DeptNbr,...
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...
Could someone please help me write this in Python? If time
allows, it you could include comments for your logic that would be
of great help.
This problem involves writing a program to analyze historical win-loss data for a single season of Division I NCAA women's basketball teams and compute from this the win ratio for each team as well as the conference(s) with the highest average win ratio. Background Whether it's football, basketball, lacrosse, or any other number of...
Most questions answered within 3 hours.
-
Draw a compact ladder logic diagram for an XOR function on the
rungs below using only...
asked 20 minutes ago -
In a multiple regression analysis, two independent variables are
considered, and the sample size is 26....
asked 3 hours ago -
FOR JAVA:
Summary: Write a program to assess password stringency.
The solution should be named Password.java....
asked 3 hours ago -
2. (1.5pt) Calculate [ClO-] in a 6.00% bleach solution. A 6.00%
bleach solution contains 6.00g of...
asked 4 hours ago -
Protons in cosmic rays have been observed with kinetic energies
as large as 1.0×1020eV.
How fast...
asked 5 hours ago -
How do you explain that it is not fair for teachers to verbally
abuse you over...
asked 5 hours ago -
Ang Electronics, Inc., has developed a new HD DVD. If the HD DVD
is successful, the...
asked 6 hours ago -
which of these substances cannot behave as a lewis base in an aq
solution
a- Co...
asked 6 hours ago -
Below are some of Toyota’s (an automotive manufacturer) costs to
manufacture a car: I. Depreciation of...
asked 6 hours ago -
A random sample of 40 cups of coffee from a vending machine had
a sample mean...
asked 7 hours ago -
The mercury in a fish sample is determined to be 1.80, 1.58 and
1.64 ppm. Calculate...
asked 6 hours ago -
Suppose a photon is equally likely to be found anywhere in an
interval of 28.5 cm...
asked 7 hours ago