What is the average value of Bush# when the value for Others# is greater than 57, and the value for Bush% is 49.2%?
CREATE TABLE table_name_70 (bush_number INTEGER, others_number VARCHAR, bush_percentage VARCHAR)
SELECT AVG(bush_number) FROM table_name_70 WHERE others_number > 57 AND bush_percentage = "49.2%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_70 (bush_number INTEGER, others_number VARCHAR, bush_percentage VARCHAR) Question: What is the average value of Bush# when the value for Others# is greater than 57, and the value for Bush% is 49.2%? [/INST] SELECT AVG(bush_number) FROM table_name_70 WHERE others_number > 57 AND bush_percentage = "49.2%" </s>