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

What is the highest roll number of the school with a state authority and a decile smaller than 8?
SELECT MAX("Roll") FROM table_69120 WHERE "Authority" = 'state' AND "Decile" < '8'
SELECT MAX("Roll") FROM "table_69120" WHERE "Authority" = 'state' AND "Decile" < '8'