Table: colts_drafts_8
Columns: round
pick
overall
name
position
college

Question: Position of defensive tackle, and a Round of 4, and a Pick # smaller than 36 has what overall average?
SQL: SELECT AVG("overall") FROM colts_drafts_8 WHERE "position" = 'defensive tackle' AND "round" = 4 AND "pick" < 36

Question: Pick # that has a Name of jaimie thomas, and a Round smaller than 7 is how many numbers?
SQL: SELECT COUNT("pick") FROM colts_drafts_8 WHERE "name" = 'jaimie thomas' AND "round" < 7