SELECT count(*) ,  student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY count(*) DESC LIMIT 1
What is the maximum number of times that a course shows up in different transcripts and what is that course's enrollment id?
SELECT count ( * ) , student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY count ( * ) DESC LIMIT 1
select count ( * ) , student_course_id from transcript_contents group by student_course_id order by count ( * ) desc limit value
What is the maximum number of times that a course shows up in different transcripts and what is that course 's enrollment id ?