Task: Text to Code
Input (English): find each value of part_id in Parts table along with the number of the corresponding rows to each value
Output (English): SELECT part_name , Count ( * ) FROM Parts GROUP BY part_id