Database: district_spokesman
Question: Find the total and average population of the districts which have some spokesman.
SQL:
SELECT sum(population) ,  avg(population) FROM district WHERE district_id IN (SELECT district_id FROM spokesman_district)