human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Name, Years, Area, Authority, Decile, Roll
###Question: What is the lowest decile with a state authority and Midhirst school?
gpt
SELECT MIN Decile FROM table WHERE Authority = state AND Name = midhirst school