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