100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 3 out of 5 pages.
query should return the Full Name (NameGiven (NameFirst) NameLast), YearID, Hits, At Bats and Batting Average sorted by descending batting average.playerid Full NameyearidHitsAt BatsBatting Averagewilsoji01 James ( Jimmie ) Wilson19291283940.324873096446becklja01 Jacob Peter ( Jake ) Beckley19041795510.324863883847gehrich01 Charles Leonard ( Charlie ) Gehringer 19332046280.324840764331
5.You get into a debate regarding the level of school that professional sports players attend. Your stance is that there are plenty of baseball players who attended Ivy League schools and were good batters in addition to being scholars. Write a query to support your argument using the People, CollegePlaying and Batting tables. You must use an IN clause in the WHERE clause to identify the Ivy League schools. You have also decided that a batting average less than .4 indicates a good batter. Sort you answer by Batting Average in descending order. Your answer should return 453 rows and contain the columns below. 6.Using the Appearances table and the appropriate SET clause from slide 45 of the Chapter 3 PowerPoint presentation, find the players that played for the same teams in 2007 and 2010. Your query only needs to return the playerid and teamids. The query should return 297 rows.7.Using the Appearances table and the appropriate SET clause from slide 45 of the Chapter 3 PowerPoint presentation, find the players that played for the different teams in 2007 and 2010. Your query only needs to return the playerids and the 2007 teamid. The query should return 649 rows.