user: ### NOW ANSWER:
Question: What is the lowest decile with a State authority and Midhirst School?
Columns: ['Name', 'Years', 'Area', 'Authority', 'Decile', 'Roll']
Types: ['text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Avon School', '1–8', 'Stratford', 'State', 1.0, '48']
SQL:

assistant: SELECT MIN("Decile") FROM "Table" WHERE "Authority" = 'State' AND "Name" = 'Midhirst School';