Table: nyagatare_population
Columns: rank_in_nyagatare_sectors_2012
sector
area_in_sqkm
population_august_15_2012
population_august_15_2002
population_change_2002_2012
population_density_2012_km_2

Question: What is the August 15, 2012 population when the  population density of 2012 is 307?
SQL: SELECT MAX("population_august_15_2012") FROM nyagatare_population WHERE "population_density_2012_km_2" = 307

Question: What is the sector when the population change 2002-2012 (%) is 79.6?
SQL: SELECT "sector" FROM nyagatare_population WHERE "population_change_2002_2012" = '79.6'

Question: For the sector of Gatunda how many entires are show for the August 15, 2012 population?
SQL: SELECT COUNT("population_august_15_2012") FROM nyagatare_population WHERE "sector" = 'Gatunda'

Question: When the population change 2002-2012 (%) is 35.5 what is the rank in nyagatare sectors?
SQL: SELECT MAX("rank_in_nyagatare_sectors_2012") FROM nyagatare_population WHERE "population_change_2002_2012" = '35.5'

Question: What is the population density for 2012 for Gatunda sector?
SQL: SELECT MIN("population_density_2012_km_2") FROM nyagatare_population WHERE "sector" = 'Gatunda'

Question: What is the highest population for the 
SQL: SELECT MAX("population_august_15_2002") FROM nyagatare_population