write a sql query to show the full team name and the number of wins in the 2020 season for each team

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Problem 1: A data science team wants to analyze the performance of professional baseball teams against the economic indicators for the region where the team plays their home games. The researchers will be using MSA, or metropolitan statistical area, to identify each team’s region. They will use statistics about the top 20 industries in that MSA, as well as GDP per capita, in their first round of analysis, when they will only be looking at end-of-season results for each baseball team.

Use the ERD on page 5 of this document, with the context given above, to answer the questions below.

(A) Write a SQL query to show the full team name and the number of wins in the 2020 season for each team.

(B) Write a SQL query to add the GDP per capita for Charlotte in 2017, which was 58,064. Charlotte’s MSA ID is 16740.

(C) Write a SQL query to show the description of every MSA in the database, along with the league, division, and full team name of any teams within the MSA.

(D) Write a SQL query to create the TEAM table. Each team will have a three letter code that identifies them (examples: PIT, NYY), will be in one of two leagues (NL or AL are the only possible values), and will be in one of three divisions (East, West, and Central are the only possible values).

(E) Write a SQL query to show the average GDP per capita in Charlotte for the years 2010-2020.

(F) Write a SQL query to show the year, value, and industry for all industry earnings entries from Charlotte in 2019.

Attachments:

Expert's Answer

1170 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme