Table: us_state_overview
Columns: department
creation
order_of_succession
2007_budget_in_billions_of_dollars
employees_2007

Question: What was the order of succession for the department of education?
SQL: SELECT "order_of_succession" FROM us_state_overview WHERE "department" = 'education'

Question: What was the highest 2007 budget when the order of succession was 3?
SQL: SELECT MAX("2007_budget_in_billions_of_dollars") FROM us_state_overview WHERE "order_of_succession" = '3'