CREATE TABLE table_14693 ("Name" TEXT, "Years" TEXT, "Area" TEXT, "Authority" TEXT, "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'