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

How many house colours are associated with house names of Hillary?
SELECT COUNT("House colour") FROM table_23003 WHERE "House name" = 'Hillary'
SELECT COUNT("House colour") FROM "table_23003" WHERE "House name" = 'Hillary'