How many gains have a long greater than 8, with avg/g of 124.9?
CREATE TABLE table_name_27 (gain INTEGER, long VARCHAR, avg_g VARCHAR)
SELECT SUM(gain) FROM table_name_27 WHERE long > 8 AND avg_g = 124.9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (gain INTEGER, long VARCHAR, avg_g VARCHAR) Question: How many gains have a long greater than 8, with avg/g of 124.9? [/INST] SELECT SUM(gain) FROM table_name_27 WHERE long > 8 AND avg_g = 124.9 </s>