Lost of 42, and a Goalsfor larger than 195 contains how many number of games?
CREATE TABLE table_name_43 (games VARCHAR, lost VARCHAR, goalsfor VARCHAR)
SELECT COUNT(games) FROM table_name_43 WHERE lost = 42 AND goalsfor > 195
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (games VARCHAR, lost VARCHAR, goalsfor VARCHAR) Question: Lost of 42, and a Goalsfor larger than 195 contains how many number of games? [/INST] SELECT COUNT(games) FROM table_name_43 WHERE lost = 42 AND goalsfor > 195 </s>