PLEASE WRITE OUT THE SQL QUERY TO THESE QUESTIONS BASED ON WHAT YOU SEE FROM THE TABLE!

THE ANSWER TO THE QUESTIONS BELOW ARE NOT IN PARAGRAPH. PLEASE WRITE OUT THE SQL QUERY!

1. Table: nfl_combine

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 pickround picktotal 2013 Oday Abousti 9 0 26 20 14 14 2013 Robert Alfard 2013 Keenan Allen . 2013 Zach Allen . 2013 David Amerson - 2013 OJ. Anderson 0 19 19 O 0 0 2013 71y Ansan w... 2013 Marc Anthony 41 41 13 13 H 20 20 0 0 Rally firstname lastname position heightfeet heightinches heightinchestotal weight arms hands fortyyd twentyyd tenyd twentyss threecane vertical broad bench round college pick Oday Aboushi OT B 6 77 200 23.975 10.625 5.45 01.09 4.94 7.62 23.5 100 17 5 Virginia 8:141) Robert Alford CD 5 10 70 163 32 9.5 4.30 01.52 4.23 8.89 40 132 17 2 Southeastern Louisiana 23180) Keenan Allen VAR 6 2.5 74,5 206 82.75 104.71 0 D 0 0 D 0 3 California 14176) Zach Allen ... OG B 2 74 332 33.5 9.875 D 0 D 0 0 0 32 O NULL NULL . David Armerson CD B 1 73 205 32.825 10.5 4.44 0 1.52 4.13 0 35.5 127 15 2 North Carolina State 19151) . G Anderson RB 5 8 F8 224 30 9 4.6 01.58 4.12 7.15 119 17 O NULL NULL ........ 71gay Ansah DF 6 5.25 77.25 271 35.125 10.25 4.68 0 1.561 4.25 7.11 118 21 O NULI NILI . 12049 . Marc Anthony CO 5 11 71 196 32.125 9 4.83 0 1.58 4.07 8.74 35 12 7 California 41/2471 Terror Armstead 27 OT 6 . 5 77 306 34 9.25 4.71 0 1.64 7.62 34,5 1. 112 31 3 Arkansas-Pine Blutt 13175) ... Austin pic WR Tavan . van 5 8 68 174 301 9.125 4.34 4.41 D 82 120 14 1 West Virginia 878) Jeff Baca OG 25 6 a Blue DAL 75 3 . 302 34.25 0.75 7.28 5.03 0 1.68 4.44 28.5 100 0 B UCLA 20188 .. ... AM Balley OG 6 3 75 312 34.75 9.375 4.95 0 1.74 NI 0 0 0 0 27 O NULL NULL 100 Balay 20 in Stedman 5 70 1933 112 van 1 9.875 4.52 153 82.75 117 4.09 0 1.58 "" 11 Wort 6.81 . 3 West Virginia 301197) Bakhtiari David OT 6 4 76 299 34 9.5 5.00 0 1.79 4.74 We 7.7 25.5 101 28 4 Colorado 1211091 We RB 5 10 Ball 70 10 214 32.825 4.4 9 4.86 10 0 1.59 118 8.88 9.00 32 281581 15 2 Weconein -9180 Jahnthan Banks CA kirin 66 2 74 4.61 18 33.875 9.25 0 1.59 4.27 6.97 34 125 10 *** 2 Mississipol State 11143) Chris Barker OG 6 3 75 305 33 9.375 5.25 0 1.77 4.77 8.09 27.5 w 99 O NULL 29 w Wars. NULL Kerion Banner RB 5 9 69 188 186 29.825 8.125 4.52 0 1.6 42 8.87 35.5 122 20 6 Oregon Sleeg 1411821 cerca T Barnes DT 6 362 34.875 10.75 5.3 0 1.BA 4916 2.26 22 97 25 O NULI NIA Sam Barrington ILB 1 78 246 82.25 10.25 4.91 0 1.67 0 D 22.5 117 a NULL NULL David Bass DE 6 3.75 75.75 262 33.5 10.5 0 1.67 4.33 7.07 30.5 110 20 7 Missouri Western 2712331 STAVA Beauharnais 18 66 1 78 240 82.75 9.125 4.84 0 1.63 42 GBA 83 118 19 7 Pigars 29178 Nick Bacton OT G 5 77 323 86.5 9 5.2 0 1.76 4.57 7.77 29.5 109 19 a NULL NULL Leveon Bell RB 6 1. 73 230 31.5 9.825 4.8 0 1.55 4.24 8.75 31.5 118 24 2 Michigan State 18148) Giovani Barnard 5 8 68 202 28 9.375 4.53 0 1.53 4.12 6.91 83.5 122 19 2 North Carina 537) Tommy Bahanon RS 6 1 78 246 30.126 10 4.88 0 1.63 4.42 85 119 7 Wake Forest 9215) 30 30 12 1 2013 Terron Armstead 2012 Tourdin 2013 Tavan Austin w 2013 Jeff Baca 2013 Avin Balley 2013 Stedman Baley 2013 David Bakhtiar 2013 Montee Bal 2013 Janthan Banks winan 2013 Chris Barker 2013 Kenion Barner adresas 2013 T.J. Barnes 2013 Sam Harrington - 2013 David Base 12 28 28 11 " 0 0 14 14 0 0 27 27 291 29 0 0 2013 Steve Bauharnas 2013 Nick Bectan 2013 LeVeon Bell 2013 Giovani Bernard 2013 Torrmy Bahanon 18 18 5 5 9 9