How many weeks have a Winning team of yellow team, and an Event of foos it or lose it?
CREATE TABLE table_name_75 (week INTEGER, winning_team VARCHAR, event VARCHAR)
SELECT SUM(week) FROM table_name_75 WHERE winning_team = "yellow team" AND event = "foos it or lose it"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (week INTEGER, winning_team VARCHAR, event VARCHAR) Question: How many weeks have a Winning team of yellow team, and an Event of foos it or lose it? [/INST] SELECT SUM(week) FROM table_name_75 WHERE winning_team = "yellow team" AND event = "foos it or lose it" </s>