Table: bolivia_irrigation
Columns: department
projects
municipalities
farmers
irrigated_ha
bid_pronar_investment_us
local_investment_us
total

Question: What was the local investment (in $) in the projects of the department with $912,185 BID/PRONAR investment?
SQL: SELECT "local_investment_us" FROM bolivia_irrigation WHERE "bid_pronar_investment_us" = '912,185'

Question: How many farmers were included by the department with 32 projects?
SQL: SELECT MAX("farmers") FROM bolivia_irrigation WHERE "projects" = 32

Question: What department irrigated 2170 Ha?
SQL: SELECT "department" FROM bolivia_irrigation WHERE "irrigated_ha" = 2170

Question: What was the BID/PRONAR investment (in $) in the department that included 1326 farmers in its projects?
SQL: SELECT "bid_pronar_investment_us" FROM bolivia_irrigation WHERE "farmers" = 1326

Question: What was the department that got $626,798 in local investments?
SQL: SELECT "department" FROM bolivia_irrigation WHERE "local_investment_us" = '626,798'