Task: Text to Code
Input (English): SQL: SELECT Max ( student_course_id ) , course_id FROM Student_Enrolment_Courses GROUP BY course_id
Feedback: I want the number of time course apperaed in transcription contents.
Output (English): SELECT count(*) ,  student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY count(*) DESC LIMIT 1