What is the median household income where the per capita is $28,789?
CREATE TABLE table_name_27 (median_household_income VARCHAR, per_capita_income VARCHAR)
SELECT median_household_income FROM table_name_27 WHERE per_capita_income = "$28,789"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (median_household_income VARCHAR, per_capita_income VARCHAR) Question: What is the median household income where the per capita is $28,789? [/INST] SELECT median_household_income FROM table_name_27 WHERE per_capita_income = "$28,789" </s>