How many house colours are associated with house names of Hillary?
CREATE TABLE table_1942683_1 (house_colour VARCHAR, house_name VARCHAR)
SELECT COUNT(house_colour) FROM table_1942683_1 WHERE house_name = "Hillary"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1942683_1 (house_colour VARCHAR, house_name VARCHAR) Question: How many house colours are associated with house names of Hillary? [/INST] SELECT COUNT(house_colour) FROM table_1942683_1 WHERE house_name = "Hillary" </s>