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