CREATE TABLE table_1942683_1 (house_colour VARCHAR, house_name VARCHAR)

How many house colours are associated with house names of Hillary?
SELECT COUNT(house_colour) FROM table_1942683_1 WHERE house_name = "Hillary"
SELECT COUNT("house_colour") FROM "table_1942683_1" WHERE "Hillary" = "house_name"