Table: draft_picks_1975
Columns: round
pick
player
position
college

Question: What is the average value for Pick #, when Position is Linebacker, when Player is Bob Bruenig, and when Round is less than 3?
SQL: SELECT AVG("pick") FROM draft_picks_1975 WHERE "position" = 'linebacker' AND "player" = 'bob bruenig' AND "round" < 3

Question: What is the sum of Pick #, when Position is Guard, and when Round is greater than 2?
SQL: SELECT SUM("pick") FROM draft_picks_1975 WHERE "position" = 'guard' AND "round" > 2

Question: What is the average Round, when Pick # is greater than 70, and when Position is Tackle?
SQL: SELECT AVG("round") FROM draft_picks_1975 WHERE "pick" > 70 AND "position" = 'tackle'

Question: What is the lowest Round, when Position is Linebacker, and when Player is Thomas Henderson?
SQL: SELECT MIN("round") FROM draft_picks_1975 WHERE "position" = 'linebacker' AND "player" = 'thomas henderson'

Question: What is the total number of Pick #, when College is Oklahoma, and when Round is less than 4?
SQL: SELECT COUNT("pick") FROM draft_picks_1975 WHERE "college" = 'oklahoma' AND "round" < 4