What is the total number of losses for teams with less than 5 ties and more than 330 goals for?
CREATE TABLE table_name_3 (lost VARCHAR, tied VARCHAR, goals_for VARCHAR)
SELECT COUNT(lost) FROM table_name_3 WHERE tied < 5 AND goals_for > 330
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (lost VARCHAR, tied VARCHAR, goals_for VARCHAR) Question: What is the total number of losses for teams with less than 5 ties and more than 330 goals for? [/INST] SELECT COUNT(lost) FROM table_name_3 WHERE tied < 5 AND goals_for > 330 </s>