Table: aquinas_college_coed_pyes
Columns: name
gender
area
authority
decile

Question: What is the smallest decile with an Area of otumoetai?
SQL: SELECT MIN("decile") FROM aquinas_college_coed_pyes WHERE "area" = 'otumoetai'

Question: Which decile has an Area of welcome bay, and an Authority of state?
SQL: SELECT "decile" FROM aquinas_college_coed_pyes WHERE "area" = 'welcome bay' AND "authority" = 'state'

Question: How many deciles have a Gender of coed, an Authority of state, and a Name of mount maunganui school?
SQL: SELECT SUM("decile") FROM aquinas_college_coed_pyes WHERE "gender" = 'coed' AND "authority" = 'state' AND "name" = 'mount maunganui school'

Question: Which name has a Decile of 5, and an Area of tauranga?
SQL: SELECT "name" FROM aquinas_college_coed_pyes WHERE "decile" = 5 AND "area" = 'tauranga'

Question: Which Authority has a Gender of coed, a Decile smaller than 6, and an Area of merivale?
SQL: SELECT "authority" FROM aquinas_college_coed_pyes WHERE "gender" = 'coed' AND "decile" < 6 AND "area" = 'merivale'

Question: What is the smallest decile with a Name of st mary's catholic school?
SQL: SELECT MIN("decile") FROM aquinas_college_coed_pyes WHERE "name" = 'st mary''s catholic school'