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)
SELECT TOP 1 COUNT(*), student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Transcript_Contents (student_course_id VARCHAR) Question: How many times at most can a course enrollment result show in different transcripts? Also show the course enrollment id. [/INST] SELECT TOP 1 COUNT(*), student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY COUNT(*) DESC </s>