Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The questions in this assignment refer to the data in Major League Baseball Statistics. How many players were born in February? 1 , 5 2

The questions in this assignment refer to the data in Major League Baseball Statistics.
How many players were born in February?
1,523 people were born in February
How many players were born on February 29?
14 players were born on February 29
What is the length of the longest last name for any player in major league baseball history? (Hint: add a column in the people tab with a formula to compute the length of the last name, and then filter or sort.)
The length of the longest last name for any player in the major league is 14 characters long. (Strange-Gordon, Van Benschoten, and Saltalamacchia).
How many home runs have been hit in major league baseball history? (Hint: select the Home run column and look in the status bar)
There have been 310,065 units in major league baseball history.
How many home runs have been hit by players born in August? (Hint: add a column in the batting tab with a vlookup formula to add in the month of the birthdate. Then do some filtering and proceed as in an earlier question.) For more details look in Modules 5 and 6.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions