user: Question: How many deciles have a Gender of Coed, an Authority of State, and a Name of Mount Maunganui School?
Columns: ['Name', 'Gender', 'Area', 'Authority', 'Decile']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['Aquinas College', 'Coed', 'Pyes Pa', 'State integrated', 9.0]
SQL:

assistant: SELECT COUNT("Decile") FROM "Table" WHERE "Gender" = 'Coed' AND "Authority" = 'State' AND "Name" = 'Mount Maunganui School';