How many Ints have a Rating smaller than 87, and Yards larger than 4?
CREATE TABLE table_name_19 (int INTEGER, rating VARCHAR, yards VARCHAR)
SELECT AVG(int) FROM table_name_19 WHERE rating < 87 AND yards > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_19 (int INTEGER, rating VARCHAR, yards VARCHAR) Question: How many Ints have a Rating smaller than 87, and Yards larger than 4? [/INST] SELECT AVG(int) FROM table_name_19 WHERE rating < 87 AND yards > 4 </s>