WRITE OUT SQL QUERY

SQL QUERY!

a) Which colleges produce the most nfl players?

b) How does the 40 yard dash, vertical, broad jump, and bench differ between athletes drafted into the NFL vs undrafted? How do the metrics vary by draft round?

c) Which colleges produce the best quarterbacks? How about other positions? How did you define the best?

d) Who is the best athlete? What metrics would you analyze to prove your case?

The bold question at the bottom is an open-ended question. There is no right or wrong answer but youll be graded on your approach and the data-driven support you provide. To answer the question thoroughly, you should aim to analyze the data 3-4 different ways to provide support for your answer.

nfl year name firstname lastname pick pickround picktotal position heightfeet heightinches heightinchestotal weight arms hands fortyd twentyyd tenyd twentyss threecone vertical broad bench round college 6 5 77 308 33.875 10.625 5.45 0 1.89 4.84 7.92 23.5 100 17 5 Virginia 2013 Oday Aboushi Oday Aboushi 8(141) 8 8 2013 Robert Alford Robert Alford 5 10 70 188 32 9.5 4.39 0 1.52 4.23 6.89 40 132 17 2 Southeastern Louisiana 28(60) 28 28 O o 2013 Keenan Allen Keenan Allen WR 6 2.5 74.5 206 32.75 10 4.71 0 0 0 0 0 3 California 14 14 o 0 14(76) NULL 2013 Zach Allen Zach Allen OG co 2 74 332 33.5 9.875 o 0 0 0 0 0 32 0 NULL 0 0 2013 David Amerson David Amerson CB 6 1 73 205 32.625 10.5 4.44 0 1.52 4.13 0 35.5 127 15 2 North Carolina State 19(51) 19 19 2013 C.J. Anderson C.J. Anderson RB 5 00 68 224 30 9 4.6 0 1.58 4.12 7.15 32 119 17 0 NULL NULL 0 0 2013 Ziggy Ansah Ziggy Ansah DE 6 5.25 77.25 271 35.125 10.25 4.63 0 1.56 4.26 7.11 34.5 118 21 0 NULL NULL 0 0 2013 Marc Anthony Marc Anthony 5 11 71 196 32.125 9 4.63 0 1.56 4.07 6.74 35 118 12 7 California 41(247) 41 11 2013 Terron Armstead Terron Armstead OT 6 5 77 306 34 9.25 4.71 0 1.64 4.72 7.62 34.5 112 31 3 Arkansas-Pine Bluff 13(75) 13 13 2013 Tavon Austin Tavon Austin WR 5 68 174 30 9.125 4.34 0 1.45 4.01 0 32 120 14 1 West Virginia 8(8) 8 8 8 3 2013 Jeff Baca Jeff Baca OG 6 75 302 34.25 9.75 5.03 0 1.68 4.44 7.26 26.5 100 0 6 UCLA 28(196) 28 28 2013 Alvin Bailey Alvin Bailey OG 6 3 75 312 34.75 9.375 4.95 0 1.74 0 0 0 0 27 0 NULL NULL 0 0 2013 Stedman Bailey Stedman Bailey WR 5 10 70 193 32.75 9.875 4.52 0 1.58 4.09 6.81 34.5 117 11 3 West Virginia 30(92) 30 30 2013 David Bakhtiari David Bakhtiari 6 4 76 299 34 9.5 5.09 0 1.79 4.74 7.7 25.5 101 28 4 Colorado 12 12 12(109) 26(58) 2013 Montee Ball Montee Ball RB 5 10 70 214 32.625 9 4.66 0 1.59 4.4 6.88 32 118 15 2 Wisconsin 26 26 2013 Johnthan Banks Johnthan Banks CB 6 2 74 185 33.875 9.25 4.61 0 1.59 4.27 6.97 34 125 10 2 Mississippi State 11(43) 11 11 2013 Chris Barker Chris Barker OG 0) 3 75 305 33 9.375 5.25 0 1.77 4.77 8.09 27.5 99 29 0 NULL NULL 0 0 2013 Kenjon Barner Kenjon Barner RB 5 9 69 196 29.625 9.125 4.52 0 1.6 4.2 6.87 35.5 122 20 6 Oregon 14(182) 14 14