Table: ashgrove_school
Columns: name
years
gender
area
authority
decile

Question: What Gender has the area of swannanoa?
SQL: SELECT "gender" FROM ashgrove_school WHERE "area" = 'swannanoa'

Question: What years had the decile smaller than 8 in the area of southbrook?
SQL: SELECT "years" FROM ashgrove_school WHERE "decile" < 8 AND "area" = 'southbrook'