CREATE TABLE table_name_71 (decile NUMBER, authority VARCHAR2, name VARCHAR2)

What is the lowest decile with a state authority and Midhirst school?
SELECT MIN(decile) FROM table_name_71 WHERE authority = "state" AND name = "midhirst school"
SELECT MIN("decile") FROM "table_name_71" WHERE "authority" = "state" AND "midhirst school" = "name"