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

What is the lowest decile with a state authority and Midhirst school?
SELECT MIN("Decile") FROM table_80132 WHERE "Authority" = 'state' AND "Name" = 'midhirst school'
SELECT MIN("Decile") FROM "table_80132" WHERE "Authority" = 'state' AND "Name" = 'midhirst school'