Table: coley_street_school
Columns: name
years
gender
area
authority
decile
roll

Question: What is the lowest decile that Ohau School has?
SQL: SELECT MIN("decile") FROM coley_street_school WHERE "name" = 'ohau school'

Question: What gender is allowed to attend the school that has a decile of 6 and a roll that is less than 179?
SQL: SELECT "gender" FROM coley_street_school WHERE "decile" = 6 AND "roll" < 179

Question: What gender is allowed at the school which has a roll of 338?
SQL: SELECT "gender" FROM coley_street_school WHERE "roll" = 338

Question: What authority controls the school in Levin that has a decile of 6, and a roll of 226?
SQL: SELECT "authority" FROM coley_street_school WHERE "decile" = 6 AND "area" = 'levin' AND "roll" = 226