Which Authority has a Gender of coed, a Decile smaller than 6, and an Area of merivale?
CREATE TABLE table_name_21 (authority VARCHAR, area VARCHAR, gender VARCHAR, decile VARCHAR)
SELECT authority FROM table_name_21 WHERE gender = "coed" AND decile < 6 AND area = "merivale"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (authority VARCHAR, area VARCHAR, gender VARCHAR, decile VARCHAR) Question: Which Authority has a Gender of coed, a Decile smaller than 6, and an Area of merivale? [/INST] SELECT authority FROM table_name_21 WHERE gender = "coed" AND decile < 6 AND area = "merivale" </s>