Table: appalachian_counties
Columns: county
population
unemployment_rate
market_income_per_capita
poverty_rate
status

Question: Which county had a 3.6% unemployment rate?
SQL: SELECT "county" FROM appalachian_counties WHERE "unemployment_rate" = '3.6%'

Question: What is the status of the county that has a 17.3% poverty rate?
SQL: SELECT "status" FROM appalachian_counties WHERE "poverty_rate" = '17.3%'

Question: What is the market income per capita of the county with the 9.4% poverty rate?
SQL: SELECT "market_income_per_capita" FROM appalachian_counties WHERE "poverty_rate" = '9.4%'

Question: How many status' are there with a population of 90565?
SQL: SELECT COUNT("status") FROM appalachian_counties WHERE "population" = 90565

Question: What is the status of the county with per capita market income of $24,326?
SQL: SELECT "status" FROM appalachian_counties WHERE "market_income_per_capita" = '$24,326'

Question: What is the unemployment rate for the county with a market income per capita of $20,958?
SQL: SELECT COUNT("unemployment_rate") FROM appalachian_counties WHERE "market_income_per_capita" = '$20,958'