Database: election
Question: For each county, find the name of the county and the number of delegates from that county.
SQL:
SELECT T1.County_name ,  COUNT(*) FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District GROUP BY T1.County_id