Table: southwest_indiana_counties
Columns: in_no
county_name
establishment_date_sw_indiana_history_statehood
county_seat
time_zone
population_2010_rank
area_sq_mi_km_2_rank
twps
zip_code_prefix_es
of_boundary_by_water

Question: When Spencer is the county  what is total of the population (2010) (rank)? 
SQL: SELECT COUNT("population_2010_rank") FROM southwest_indiana_counties WHERE "county_name" = 'Spencer'

Question: When Vincennes is the county seat what is the area sq mi (km 2 ) (rank) ?
SQL: SELECT "area_sq_mi_km_2_rank" FROM southwest_indiana_counties WHERE "county_seat" = 'Vincennes'

Question: When the  area sq mi (km 2 ) (rank) is sqmi (km2) (5) what is the  population (2010) (rank)?
SQL: SELECT "population_2010_rank" FROM southwest_indiana_counties WHERE "area_sq_mi_km_2_rank" = 'sqmi (km2) (5)'

Question: When the % of boundary by water is 63% what is the overall number of zip code prefix(es)?
SQL: SELECT COUNT("zip_code_prefix_es") FROM southwest_indiana_counties WHERE "of_boundary_by_water" = '63%'

Question: When Spencer is the county what is the  in no.?
SQL: SELECT "in_no" FROM southwest_indiana_counties WHERE "county_name" = 'Spencer'