What is the year total for teams with under 37 games tied, over 33 games, and 15 losses?
CREATE TABLE table_name_7 (years INTEGER, lost VARCHAR, tied VARCHAR, total_games VARCHAR)
SELECT SUM(years) FROM table_name_7 WHERE tied < 37 AND total_games > 33 AND lost = 15
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (years INTEGER, lost VARCHAR, tied VARCHAR, total_games VARCHAR) Question: What is the year total for teams with under 37 games tied, over 33 games, and 15 losses? [/INST] SELECT SUM(years) FROM table_name_7 WHERE tied < 37 AND total_games > 33 AND lost = 15 </s>