Table: ohio_income_locations
Columns: rank
place
county
per_capita_income
median_house_hold_income
population
number_of_households

Question: For upper Arlington, what was the median household income?
SQL: SELECT "median_house_hold_income" FROM ohio_income_locations WHERE "place" = 'Upper Arlington'

Question: With a per capita income of $30,298, what was the total number of households?
SQL: SELECT COUNT("number_of_households") FROM ohio_income_locations WHERE "per_capita_income" = '$30,298'

Question: If the population is 2188, what was the median household income?
SQL: SELECT "median_house_hold_income" FROM ohio_income_locations WHERE "population" = 2188

Question: For Pigeon Creek what is the per capita income?
SQL: SELECT "per_capita_income" FROM ohio_income_locations WHERE "place" = 'Pigeon Creek'

Question: If the median income is $57,407, what is the per capita income?
SQL: SELECT "per_capita_income" FROM ohio_income_locations WHERE "median_house_hold_income" = '$57,407'