Task: Text to Code
Input (English): Step 1: find the number of rows of each value of dept_name in course table.
Step 2: find title, credits, dept_name in course table whose corresponding value in step 1 is greater than 1
Output (English): SELECT title , credits , dept_name FROM course GROUP BY dept_name HAVING Count ( * ) > 1