Calculate the percentage of the team

Assignment Help Management Information Sys

Reference no: EM133437893

Question: Now you decide to pull all the information you've developed together.

Write a query that shows the player's Total_bases_touched from question #5, the batting_averages from #9 (between .2and .4999)
and the player's name as formatted in #8. You also want to add the teamid and the team's batting average for the year.

The teams batting average should be calculated using the columns with the same names, but from the TEAMS table.

As a final piece of information, calculate the percentage of the team's batting average divided by the player's batting average.

Also replace the Teamid with the team name in your ourput. Note, a percentage over 100% indicates the player is better than the average batter on the team.

Additionally, rename the tables to only use the first letter of the table so you can use that the select and where statement (ex: FROM TEAMS T).

This saves a considerable amount of typing and makes the query easier to read. Order the results by batting average in descending order then playerid and yearid id ascending order.

Also, eliminate any results where the player has an AB less than 50. Your query should return 44,272 rows.

Reference no: EM133437893

Questions Cloud

Identify one potential network threat to your business : Identify one potential network threat to your business and Discuss 1 significance of using OSI, TCP/IP, and SANS 20 Controls in network protection

Explain how you plan to determine the scope : Explain how you plan to determine the scope of a website project so that you can deliver a successful project to your customer. Explain your response

Discuss inherent legal challenges to these behaviors : Discuss the inherent legal challenges to these behaviors, which can essentially amount to practicing without a license.

Describe and explain the vulnerability : Describe and explain the vulnerability with a reasonable high level of technical detail. A copy of a CVE report is not acceptable, and a superficial description

Calculate the percentage of the team : Write a query that shows the players Total_bases_touched from question - calculate the percentage of the team's batting average divided by the players batting

Describe how organization builds community capacity : Describe how the organization builds community capacity. How do they build on the strengths/assets of the participants or community members?

Communicate the benefits of microservices architecture : Communicate the benefits of microservices architecture to a diverse stakeholder audience by addressing complex business needs and aligning strategies

Josh mental health formulation : How do you think the AOD Service might managed privacy and confidentiality in accessing Josh's Mental Health Formulation?

Implement the basics of pfsense post-installation : implement the basics of pfSense post-installation configuration - Choose social media website and disable all domains for that website

User Account

All Pages