Database: district_spokesman
Question: Find the number of spokesmen for each district, and the show district names as well.
SQL:
SELECT t1.name ,  count(*) FROM district AS t1 JOIN spokesman_district AS t2 ON t1.District_ID  =  t2.District_ID GROUP BY t2.District_ID