Table: school_list
Columns: name
years
area
authority
decile
roll

Question: What is the Onehunga school with a decile 3 and smaller than 310 rolls?
SQL: SELECT "name" FROM school_list WHERE "decile" = '3' AND "roll" < 310 AND "area" = 'onehunga'

Question: What is the authority status of the school in Ellerslie with a decile of 7?
SQL: SELECT "authority" FROM school_list WHERE "area" = 'ellerslie' AND "decile" = '7'

Question: What is the biggest roll number of Sylvia Park School, which has a state authority?
SQL: SELECT MAX("roll") FROM school_list WHERE "authority" = 'state' AND "name" = 'sylvia park school'

Question: What is the name of the school with a decile of 1, a state authority, and located in Otahuhu?
SQL: SELECT "name" FROM school_list WHERE "decile" = '1' AND "authority" = 'state' AND "area" = 'otahuhu'