How many house colours are associated with house names of Hillary?
create table table_1942683_1 (house_colour varchar, house_name varchar, PRIMARY KEY (house_colour))
select count(house_colour) from table_1942683_1 where house_name = "hillary"