What is the median household income in Valley County?
CREATE TABLE table_name_8 (median_household_income VARCHAR, county VARCHAR)
SELECT median_household_income FROM table_name_8 WHERE county = "valley"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (median_household_income VARCHAR, county VARCHAR) Question: What is the median household income in Valley County? [/INST] SELECT median_household_income FROM table_name_8 WHERE county = "valley" </s>