Question

WRITE OUT THE SQL QUERY
1. Table: nfl_combine
The schema includes:
- year
- name
- firstname
- lastname
- position
- heightfeet
- heightinches
- heightinchestotal
- weight
- arms
- hands
- fortyyd
- twentyyd
- tenyd
- twentyss
- threecone
- vertical
- broad
- bench
- round
- college
- pick
- pickround
- picktotal

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?

Answer 1

Answer:

read all question

and it's too long