What is the 2007 Team with player Deshaun Foster?
CREATE TABLE table_name_30 (player VARCHAR)
SELECT 2007 AS _team FROM table_name_30 WHERE player = "deshaun foster"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (player VARCHAR) Question: What is the 2007 Team with player Deshaun Foster? [/INST] SELECT 2007 AS _team FROM table_name_30 WHERE player = "deshaun foster" </s>