Table: chanel_college
Columns: name
years
gender
area
authority
decile

Question: Name the authority for coed gender and chanel college
SQL: SELECT "authority" FROM chanel_college WHERE "gender" = 'coed' AND "name" = 'chanel college'

Question: Name the average decile for state authority and area of fernridge
SQL: SELECT AVG("decile") FROM chanel_college WHERE "authority" = 'state' AND "area" = 'fernridge'