How much Avg/G has a Gain smaller than 1571, and a Long smaller than 46?
CREATE TABLE table_name_81 (avg_g VARCHAR, gain VARCHAR, long VARCHAR)
SELECT COUNT(avg_g) FROM table_name_81 WHERE gain < 1571 AND long < 46
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_81 (avg_g VARCHAR, gain VARCHAR, long VARCHAR) Question: How much Avg/G has a Gain smaller than 1571, and a Long smaller than 46? [/INST] SELECT COUNT(avg_g) FROM table_name_81 WHERE gain < 1571 AND long < 46 </s>