user: Question: How many house mascots are associated with Yellow house colours?
Columns: ['House name', 'House mascot', 'House colour', 'Year opened', 'House leader']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Hillary', 'Yeti', 'Green', 1980.0, 'Mrs Wong']
SQL:

assistant: SELECT COUNT("House mascot") FROM "Table" WHERE "House colour" = 'Yellow';