How much is per capita income when median household income is $42,845?
CREATE TABLE table_name_43 (per_capita_income VARCHAR, median_household_income VARCHAR)
SELECT per_capita_income FROM table_name_43 WHERE median_household_income = "$42,845"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (per_capita_income VARCHAR, median_household_income VARCHAR) Question: How much is per capita income when median household income is $42,845? [/INST] SELECT per_capita_income FROM table_name_43 WHERE median_household_income = "$42,845" </s>