CREATE TABLE county (County_name VARCHAR2, County_id VARCHAR2)
CREATE TABLE election (District VARCHAR2)

Show the name of each county along with the corresponding number of delegates from that county.
SELECT T1.County_name, COUNT(*) FROM county AS T1 JOIN election AS T2 ON T1.County_id = T2.District GROUP BY T1.County_id
SELECT "T1"."County_name", COUNT(*) FROM "county" "T1" JOIN "election" "T2" ON "T1"."County_id" = "T2"."District" GROUP BY "T1"."County_id"