CREATE TABLE table_16799 ("House Name" CLOB, "Composition" CLOB, "Named after" CLOB, "Founded" FLOAT, "Colours" CLOB)

How many houses are green?
SELECT COUNT("House Name") FROM table_16799 WHERE "Colours" = 'Green'
SELECT COUNT("House Name") FROM "table_16799" WHERE "Colours" = 'Green'