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

Question: What's the authority when the roll is 40?
SQL: SELECT "authority" FROM birdwood_school WHERE "roll" = 40

Question: What's the authority when the roll is less than 234 for the massey east area?
SQL: SELECT "authority" FROM birdwood_school WHERE "roll" < 234 AND "area" = 'massey east'

Question: What's the roll for summerland primary when decile is over 6?
SQL: SELECT "roll" FROM birdwood_school WHERE "decile" > 6 AND "name" = 'summerland primary'