Table: draft_picks_1991
Columns: round
pick
player
position
college

Question: Which college did Dean Kirkland go to
SQL: SELECT "college" FROM draft_picks_1991 WHERE "player" = 'Dean Kirkland'

Question: Which player went to Pittsburg State
SQL: SELECT "player" FROM draft_picks_1991 WHERE "college" = 'Pittsburg State'

Question: Who was the highest pick
SQL: SELECT MIN("pick") FROM draft_picks_1991

Question: Who was the highest picked defensive end
SQL: SELECT MAX("pick") FROM draft_picks_1991 WHERE "position" = 'Defensive end'

Question: How many players named Dean Kirkland were picked
SQL: SELECT COUNT("pick") FROM draft_picks_1991 WHERE "player" = 'Dean Kirkland'