CREATE TABLE table_name_71 (decile INT, authority VARCHAR, name VARCHAR)

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"