How many times at most can a course enrollment result show in different transcripts? Also show the course enrollment id.
create table transcript_contents (student_course_id varchar, PRIMARY KEY (student_course_id))
select count(*), student_course_id from transcript_contents group by student_course_id order by count(*) desc limit 1