Table schema:
CREATE TABLE table_11464746_1 (house_name VARCHAR, colours VARCHAR)

Question: How many houses are green?
SQL: SELECT COUNT(house_name) FROM table_11464746_1 WHERE colours = "Green"