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

Question: What is the lowest Decile for a school with a roll smaller than 3?
SQL: SELECT MIN("decile") FROM hapuku_school WHERE "roll" < 3

Question: What is the Gender of students at a school with a Decile of 5 and a Roll of 90?
SQL: SELECT "gender" FROM hapuku_school WHERE "decile" = 5 AND "roll" = 90

Question: Name the Years of schools with a Roll Larger than 23 and a Decile greater than 5.
SQL: SELECT "years" FROM hapuku_school WHERE "roll" > 23 AND "decile" > 5

Question: What is the total number of Rolls of State schools in Hapuku with a Decile greater than 4?
SQL: SELECT COUNT("roll") FROM hapuku_school WHERE "authority" = 'state' AND "area" = 'hapuku' AND "decile" > 4