Task: Text to Code
Input (English): find each value of dept_name in student table along with the summation of tot_cred of the corresponding rows to each value
Output (English): SELECT Sum ( tot_cred ) , dept_name FROM student GROUP BY dept_name