Table: draft_players
Columns: pick
nfl_team
player
position
college

Question: Which Position has a Pick # lower than 278 for Player Charles Benson?
SQL: SELECT "position" FROM draft_players WHERE "pick" < 278 AND "player" = 'charles benson'

Question: Which Player has a Pick # lower than 223 and a Defensive End Position?
SQL: SELECT "player" FROM draft_players WHERE "pick" < 223 AND "position" = 'defensive end'

Question: If the Position is Running Back what is the Total number of Pick #?
SQL: SELECT COUNT("pick") FROM draft_players WHERE "position" = 'running back'

Question: Which College has Player Mark Brown and a Pick # greater than 195?
SQL: SELECT "college" FROM draft_players WHERE "pick" > 195 AND "player" = 'mark brown'