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
Find the number of spokesmen for each district, and the show district names as well.
CREATE TABLE "district" (
"District_ID" int,
"Name" text,
"Area_km" real,
"Population" real,
"Density_km" real,
"Government_website" text,
PRIMARY KEY ("District_ID")
);
CREATE TABLE "spokesman" (
"Spokesman_ID" int,
"Name" text,
"Age" int,
"Speach_title" text,
"Rank_position" real,
"Points" real,
PRIMARY KEY ("Spokesman_ID")
);
CREATE TABLE "spokesman_district" (
"Spokesman_ID" int,
"District_ID" int,
"Start_year" text,
PRIMARY KEY ("Spokesman_ID"),
FOREIGN KEY ("Spokesman_ID") REFERENCES "spokesman"("Spokesman_ID"),
FOREIGN KEY ("District_ID") REFERENCES "district"("District_ID")
);
INSERT INTO  "district" VALUES (1,"Pozo Almonte","13765.8","10830","0.8","linke.gov");
INSERT INTO "spokesman" VALUES ("1","Rocco Granata",45,"Life and Freedom","1","498");
INSERT INTO "spokesman_district" VALUES (1,1,"2003");