What's the total long for more than 24 loss, a gain over 273, and an avg/g of 207.8?
CREATE TABLE table_name_19 (long INTEGER, avg_g VARCHAR, loss VARCHAR, gain VARCHAR)
SELECT SUM(long) FROM table_name_19 WHERE loss > 24 AND gain > 273 AND avg_g = 207.8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_19 (long INTEGER, avg_g VARCHAR, loss VARCHAR, gain VARCHAR) Question: What's the total long for more than 24 loss, a gain over 273, and an avg/g of 207.8? [/INST] SELECT SUM(long) FROM table_name_19 WHERE loss > 24 AND gain > 273 AND avg_g = 207.8 </s>