Table: appalachian_counties_data
Columns: county
population
unemployment_rate
market_income_per_capita
poverty_rate
status

Question: What is the population in those place where the market income per capita is $17,362?
SQL: SELECT "population" FROM appalachian_counties_data WHERE "market_income_per_capita" = '$17,362'

Question: What is the unemployment rate in those places where the market income per capita is $16,981?
SQL: SELECT COUNT("unemployment_rate") FROM appalachian_counties_data WHERE "market_income_per_capita" = '$16,981'

Question: What is the status in those places where the poverty rate is 8.6%?
SQL: SELECT "status" FROM appalachian_counties_data WHERE "poverty_rate" = '8.6%'

Question: What is the unemployment rate in those places in Alexander county whose status is transitional?
SQL: SELECT "unemployment_rate" FROM appalachian_counties_data WHERE "status" = 'Transitional' AND "county" = 'Alexander'

Question: What is the population of the country of McDowell?
SQL: SELECT "population" FROM appalachian_counties_data WHERE "county" = 'McDowell'

Question: In what counties is the unemployment rate 5.8% and the market income per capita is $22,866?
SQL: SELECT "county" FROM appalachian_counties_data WHERE "unemployment_rate" = '5.8%' AND "market_income_per_capita" = '$22,866'