Table: agua_clara_project
Columns: location
partner
construction_start
inauguration_date
population_served
design_flow_lpm

Question: What Location has a Partner of app, a Population Served larger than 2000, and a Design flow (LPM) of 375?
SQL: SELECT "location" FROM agua_clara_project WHERE "partner" = 'app' AND "population_served" > 2000 AND "design_flow_lpm" = 375

Question: What Construction Start has an Inauguration Date of 2010 june?
SQL: SELECT "construction_start" FROM agua_clara_project WHERE "inauguration_date" = '2010 june'

Question: What Construction Start has a Design flow (LPM) of 1300?
SQL: SELECT "construction_start" FROM agua_clara_project WHERE "design_flow_lpm" = 1300

Question: What Location has a Design flow (LPM) smaller than 1900, and a Construction Start of 2006 june?
SQL: SELECT "location" FROM agua_clara_project WHERE "design_flow_lpm" < 1900 AND "construction_start" = '2006 june'

Question: What Partner has a Construction Start of 2008 january?
SQL: SELECT "partner" FROM agua_clara_project WHERE "construction_start" = '2008 january'

Question: What is the total Design flow (LPM) with a Partner of app, a Construction Start of 2008 january, and a Population Served larger than 3500?
SQL: SELECT SUM("design_flow_lpm") FROM agua_clara_project WHERE "partner" = 'app' AND "construction_start" = '2008 january' AND "population_served" > 3500