CREATE TABLE table_23005 ("House name" CLOB, "House mascot" CLOB, "House colour" CLOB, "Year opened" FLOAT, "House leader" CLOB)

How many house mascots are associated with yellow house colours?
SELECT COUNT("House mascot") FROM table_23005 WHERE "House colour" = 'Yellow'
SELECT COUNT("House mascot") FROM "table_23005" WHERE "House colour" = 'Yellow'