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

Question: What is the total roll with a decile less than 7, and an authority of state, in the Macraes Flat area?
SQL: SELECT COUNT("roll") FROM ardgowan_school WHERE "decile" = 7 AND "authority" = 'state' AND "area" = 'macraes flat'

Question: What year has a decile more than 6, in the Waikouaiti area?
SQL: SELECT "years" FROM ardgowan_school WHERE "decile" > 6 AND "area" = 'waikouaiti'