How many houses are green?
CREATE TABLE table_11464746_1 (house_name VARCHAR, colours VARCHAR)
SELECT COUNT(house_name) FROM table_11464746_1 WHERE colours = "Green"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11464746_1 (house_name VARCHAR, colours VARCHAR) Question: How many houses are green? [/INST] SELECT COUNT(house_name) FROM table_11464746_1 WHERE colours = "Green" </s>