CREATE TABLE table_name_93 (decile INT, name VARCHAR, gender VARCHAR, authority VARCHAR)

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