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"