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