What is the average long that has 1581 as a gain, with a loss less than 308?
CREATE TABLE table_name_72 (long INTEGER, gain VARCHAR, loss VARCHAR)
SELECT AVG(long) FROM table_name_72 WHERE gain = 1581 AND loss < 308
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_72 (long INTEGER, gain VARCHAR, loss VARCHAR) Question: What is the average long that has 1581 as a gain, with a loss less than 308? [/INST] SELECT AVG(long) FROM table_name_72 WHERE gain = 1581 AND loss < 308 </s>