SELECT T3.course_name ,  count(*) FROM students AS T1 JOIN student_course_registrations AS T2 ON T1.student_id = T2.student_id JOIN courses AS T3 ON T2.course_id = T3.course_id GROUP BY T2.course_id
For each course id, how many students are registered and what are the course names?
SELECT T3.course_name , count ( * ) FROM students AS T1 JOIN student_course_registrations AS T2 ON T1.student_id = T2.student_id JOIN courses AS T3 ON T2.course_id = T3.course_id GROUP BY T2.course_id
select t3 . course_name , count ( * ) from students as t1 join student_course_registrations as t2 on t1 . student_id = t2 . student_id join courses as t3 on t2 . course_id = t3 . course_id group by t2 . course_id
For each course id , how many students are registered and what are the course names ?