CREATE TABLE table_14693 ("Name" CLOB, "Years" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

What is the average roll of a school with state authority and a decile of 9?
SELECT AVG("Roll") FROM table_14693 WHERE "Authority" = 'state' AND "Decile" = '9'
SELECT AVG("Roll") FROM "table_14693" WHERE "Authority" = 'state' AND "Decile" = '9'