In this lab you'll query data from a table populated with Babe Ruth's career hitting statistics. Then you'll use aggregate functions to pull interesting information from the table that basic queries cannot track.

• Write queries with aggregate functions like COUNT, MAX, MIN, and SUM
• Create an alias for the return value of an aggregate function
• Use GROUP BY to sort the data sets returned by aggregate functions
• Compare aggregates using the HAVING clause

We will query from the babe_ruth_stats table featured below.

#Your code here

Return the total number of years that Babe Ruth played professional baseball.

#Your code here

Return the total number of years Babe Ruth played with the NY Yankees.

#Your code here

Select the row with the most HR that Babe Ruth hit in one season

#Your code here

Select the row with the least number of HR hit in one season.

#Your code here

Return the total number of HR hit by Babe Ruth during his career

#Your code here

Above you saw that Babe Ruth hit 0 home runs in his first year when he played only five games. To avoid this and other extreme outliers, first filter the data to those years in which Ruth played in at least 100 games. Then, select all of the columns for the 5 worst seasons, in terms of the number of home runs, where he played over 100 games.

#Your code here

Select the average, AVG, of Ruth's batting averages. The header of the result would be AVG(AVG) which is quite confusing, so provide an alias of career_average.

#Your code here

Select the total number of years played and hits Babe Ruth had for each team he played for.

#Your code here

We want to know the years in which Ruth successfully reached base over 300 times. We need to add hits and BB to calculate how many times Ruth reached base. Simply add the two columns together (ie: SELECT hits + BB FROM ...) and give this value an alias of on_base. Select the year and on_base for only those years with an on_base over 300.

#Your code here

Well done! In this lab, you continued adding complexity to SQL statements and wrote aggregate functions. You were able to build queries that showed the total years and home runs earned by team as well as calculating Babe Ruth's total on base and then selecting only years that met a minimum value of our calculated on the base attribute.