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

Question: What is the lowest roll number of Katikati college?
SQL: SELECT MIN("roll") FROM fairhaven_school WHERE "name" = 'katikati college'

Question: What is the highest roll number of the school in Te puna with a decile larger than 2?
SQL: SELECT MAX("roll") FROM fairhaven_school WHERE "decile" > 2 AND "area" = 'te puna'

Question: What is the roll number of Te Puke Intermediate, which has a decile of 4?
SQL: SELECT "roll" FROM fairhaven_school WHERE "decile" = 4 AND "name" = 'te puke intermediate'

Question: What is the highest roll number of the school with a state authority and a decile smaller than 8?
SQL: SELECT MAX("roll") FROM fairhaven_school WHERE "authority" = 'state' AND "decile" < 8