Update: I’ve added the 2nd and 3rd rounds into the data set.
I’ve been on a mission to learn SQL and decided to create a data set of the 2016 NFL draft. The following are some insights I found by through querying:
- The average first round draft pick is 6′ 3″ and 243 pounds.
- 7 players drafted were taller or equal to 6′ 6″.
- There tallest player drafted was 6′ 7″ and the shortest player drafted was 5′ 10″.
- Ohio State had the most players (5) drafted in the first round.
- There were 14 offensive players and 17 defensive players drafted.
- CB, OT, WR were the most positions drafted with 5 players going in the first round in each position group.
The data set can be found below. I’m still considering adding the 2nd and 3rd rounds to the data set.