What state has Richard Foster as a member?
CREATE TABLE table_name_49 (state VARCHAR, member VARCHAR)
SELECT state FROM table_name_49 WHERE member = "richard foster"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_49 (state VARCHAR, member VARCHAR) Question: What state has Richard Foster as a member? [/INST] SELECT state FROM table_name_49 WHERE member = "richard foster" </s>