SELECT T1.semester_name ,  T1.semester_id FROM Semesters AS T1 JOIN Student_Enrolment AS T2 ON T1.semester_id  =  T2.semester_id GROUP BY T1.semester_id ORDER BY count(*) DESC LIMIT 1
For each semester, what is the name and id of the one with the most students registered?
SELECT T1.semester_name , T1.semester_id FROM Semesters AS T1 JOIN Student_Enrolment AS T2 ON T1.semester_id = T2.semester_id GROUP BY T1.semester_id ORDER BY count ( * ) DESC LIMIT 1
select t1 . semester_name , t1 . semester_id from semesters as t1 join student_enrolment as t2 on t1 . semester_id = t2 . semester_id group by t1 . semester_id order by count ( * ) desc limit value
For each semester , what is the name and id of the one with the most students registered ?