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