Table: federal_govt_college_ikot
Columns: house_name
composition
named_after
founded
colours

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

Question: What year was the house named gongola made?
SQL: SELECT "founded" FROM federal_govt_college_ikot WHERE "house_name" = 'Gongola'

Question: What is the name of the green house?
SQL: SELECT "house_name" FROM federal_govt_college_ikot WHERE "colours" = 'Green'

Question: What is the green house made of?
SQL: SELECT "composition" FROM federal_govt_college_ikot WHERE "colours" = 'Green'

Question: What is the benue house made of?
SQL: SELECT "composition" FROM federal_govt_college_ikot WHERE "house_name" = 'Benue'