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

What were the years for Redhill school, authority of state?
SELECT "Years" FROM table_57831 WHERE "Authority" = 'state' AND "Name" = 'redhill school'
SELECT "Years" FROM "table_57831" WHERE "Authority" = 'state' AND "Name" = 'redhill school'