Task: Text to Code
Input (English): find each value of course_id in Student_Enrolment_Courses table along with the maximum student_course_id of the corresponding rows to each value
Output (English): SELECT Max ( student_course_id ) , course_id FROM Student_Enrolment_Courses GROUP BY course_id