What are the ids of all students for courses and what are the names of those courses?
select t1.student_id, t2.course_name from student_course_registrations as t1 join courses as t2 on t1.course_id = t2.course_id