Table: draft_picks_1974
Columns: round
pick
player
position
college

Question: A Round larger than 1, a College of Oklahoma state, and a average Pick # that has a Position of tight end is what?
SQL: SELECT AVG("pick") FROM draft_picks_1974 WHERE "position" = 'tight end' AND "college" = 'oklahoma state' AND "round" > 1

Question: A Pick # larger than 339 and the College that has a Round of 14 is what?
SQL: SELECT "college" FROM draft_picks_1974 WHERE "round" = 14 AND "pick" > 339

Question: Pick # of 331 went to which college?
SQL: SELECT "college" FROM draft_picks_1974 WHERE "pick" = 331

Question: Pick # of 203 went to which college?
SQL: SELECT "college" FROM draft_picks_1974 WHERE "pick" = 203