How many deciles have a Gender of coed, an Authority of state, and a Name of mount maunganui school?
CREATE TABLE table_name_93 (decile INTEGER, name VARCHAR, gender VARCHAR, authority VARCHAR)
SELECT SUM(decile) FROM table_name_93 WHERE gender = "coed" AND authority = "state" AND name = "mount maunganui school"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_93 (decile INTEGER, name VARCHAR, gender VARCHAR, authority VARCHAR) Question: How many deciles have a Gender of coed, an Authority of state, and a Name of mount maunganui school? [/INST] SELECT SUM(decile) FROM table_name_93 WHERE gender = "coed" AND authority = "state" AND name = "mount maunganui school" </s>