Table: sherbrooke_boroughs
Columns: borough
components
population
number_of_borough_councilors
number_of_municipal_councilors

Question: What is the average number of borough councilors from Brompton?
SQL: SELECT AVG("number_of_borough_councilors") FROM sherbrooke_boroughs WHERE "borough" = 'brompton'

Question: Which components have a borough of Lennoxville and borough councilors under 4?
SQL: SELECT "components" FROM sherbrooke_boroughs WHERE "number_of_borough_councilors" < 4 AND "borough" = 'lennoxville'