user: ### NOW ANSWER:
Question: How many houses are Green?
Columns: ['House Name', 'Composition', 'Named after', 'Founded', 'Colours']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Benue', 'Coed', 'River Benue', 1973.0, 'Yellow']
SQL:

assistant: SELECT COUNT("House Name") FROM "Table" WHERE "Colours" = 'Green';