CREATE TABLE table_11464746_1 (house_name VARCHAR, colours VARCHAR)

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