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"
### Context: CREATE TABLE table_11464746_1 (house_name VARCHAR, colours VARCHAR) ### Question: How many houses are green? ### Answer: SELECT COUNT(house_name) FROM table_11464746_1 WHERE colours = "Green"