user: ### NOW ANSWER:
Question: in what year did the colors Red and Gold join?
Columns: ['Institution', 'Location', 'Year Joined', 'Affiliation', 'Enrollment', 'Mascot', 'Colors']
Types: ['text', 'text', 'real', 'text', 'real', 'text', 'text']
Sample row: ['Aquinas', 'La Crosse, WI', 1997.0, 'Private (Catholic)', 330.0, 'Blugolds', 'Blue and Gold']
SQL:

assistant: SELECT COUNT("Year Joined") FROM "Table" WHERE "Colors" = 'Red and Gold';