Task: Text to Code
Input (English): SQL: SELECT County_name , Count ( * ) FROM county GROUP BY County_name
Feedback: Should find the number of corresponding rows of delegate in election table for each county .
Output (English): SELECT T1.County_name ,  COUNT(*) FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District GROUP BY T1.County_id