What are the average apps for the Major League Soccer team club for the Seattle Sounders FC that has goals less than 0?
CREATE TABLE table_name_43 (apps INTEGER, goals VARCHAR, league VARCHAR, club VARCHAR)
SELECT AVG(apps) FROM table_name_43 WHERE league = "major league soccer" AND club = "seattle sounders fc" AND goals < 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (apps INTEGER, goals VARCHAR, league VARCHAR, club VARCHAR) Question: What are the average apps for the Major League Soccer team club for the Seattle Sounders FC that has goals less than 0? [/INST] SELECT AVG(apps) FROM table_name_43 WHERE league = "major league soccer" AND club = "seattle sounders fc" AND goals < 0 </s>