CREATE TABLE table_name_21 (authority VARCHAR2, area VARCHAR2, gender VARCHAR2, decile VARCHAR2)

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