What is the highest number of households with a median household income of $31,176, and a population of 25,607?
CREATE TABLE table_name_30 (number_of_households INTEGER, median_household_income VARCHAR, population VARCHAR)
SELECT MAX(number_of_households) FROM table_name_30 WHERE median_household_income = "$31,176" AND population < 25 OFFSET 607 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (number_of_households INTEGER, median_household_income VARCHAR, population VARCHAR) Question: What is the highest number of households with a median household income of $31,176, and a population of 25,607? [/INST] SELECT MAX(number_of_households) FROM table_name_30 WHERE median_household_income = "$31,176" AND population < 25 OFFSET 607 ROWS </s>