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

Question: Which gender had a decile of more than 1 and featured the South Auckland Seventh-Day Adventist School?
SQL: SELECT "gender" FROM bairds_mainfreight_primary_school WHERE "decile" > 1 AND "name" = 'south auckland seventh-day adventist school'

Question: Which name has an authority of state?
SQL: SELECT "name" FROM bairds_mainfreight_primary_school WHERE "authority" = 'state'

Question: Which decile features Mayfield School?
SQL: SELECT "decile" FROM bairds_mainfreight_primary_school WHERE "name" = 'mayfield school'