query should return the Full Name NameGiven NameFirst NameLast YearID Hits At

Query should return the full name namegiven namefirst

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 Name yearid Hits At Bats Batting Average wilsoji01 James ( Jimmie ) Wilson 1929 128 394 0.324873096446 becklja01 Jacob Peter ( Jake ) Beckley 1904 179 551 0.324863883847 gehrich01 Charles Leonard ( Charlie ) Gehringer 1933 204 628 0.324840764331
Image of page 1
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.
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture