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

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