Task: Text to Code
Input (English): SQL: SELECT Region_code , Count ( * ) FROM region GROUP BY Region_code
Feedback: Replace region code with region name , should find number of corresponding rows of each region id in affected region .
Output (English): SELECT T1.region_name ,  count(*) FROM region AS T1 JOIN affected_region AS T2 ON T1.region_id = T2.region_id GROUP BY T1.region_id