Table: adventure_school
Columns: name
gender
area
authority
decile
roll

Question: What is the roll of Bishop Viard College (An Integrated College), which has a decile larger than 1?
SQL: SELECT COUNT("roll") FROM adventure_school WHERE "decile" > 1 AND "authority" = 'integrated' AND "name" = 'bishop viard college'

Question: What was the decile of Samuel Marsden Collegiate School in Whitby, when it had a roll higher than 163?
SQL: SELECT COUNT("decile") FROM adventure_school WHERE "area" = 'whitby' AND "name" = 'samuel marsden collegiate school' AND "roll" > 163

Question: What integrated school had a decile of 2 and a roll larger than 55?
SQL: SELECT "name" FROM adventure_school WHERE "decile" = 2 AND "authority" = 'integrated' AND "roll" > 55