Table: players_contracts
Columns: pos
player
free_agent_type
2007_team
contract

Question: What is the 2007 Team with player Deshaun Foster?
SQL: SELECT "2007_team" FROM players_contracts WHERE "player" = 'deshaun foster'

Question: What is the Free Agent Type for player bryant johnson?
SQL: SELECT "free_agent_type" FROM players_contracts WHERE "player" = 'bryant johnson'