Table: draft_picks_1990_2
Columns: pick
nfl_team
player
position
college

Question: Which NFL team has a pick# less than 200 for Travis Davis?
SQL: SELECT "nfl_team" FROM draft_picks_1990_2 WHERE "pick" < 200 AND "player" = 'travis davis'

Question: Which player was a running back from San Jose State?
SQL: SELECT "player" FROM draft_picks_1990_2 WHERE "position" = 'running back' AND "college" = 'san jose state'

Question: What is the pick# from South Dakota college?
SQL: SELECT "pick" FROM draft_picks_1990_2 WHERE "college" = 'south dakota'

Question: Which college has a nose tackle position?
SQL: SELECT "college" FROM draft_picks_1990_2 WHERE "position" = 'nose tackle'