Table: schools_taranaki
Columns: name
years
area
authority
decile
roll

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