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

Where is the school with state authority that has a roll of more than 157 students?
SELECT "Area" FROM table_80078 WHERE "Authority" = 'state' AND "Roll" > '157'
SELECT "Area" FROM "table_80078" WHERE "Authority" = 'state' AND "Roll" > '157'