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