human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Week, Event, Air Date, Winning team, Winners club
###Question: How many weeks have a Winning team of yellow team, and an Event of foos it or lose it?
gpt
SELECT SUM Week FROM table WHERE Winning team = yellow team AND Event = foos it or lose it