What are the ids of all students for courses and what are the names of those courses?
create table courses (course_name varchar, course_id varchar, PRIMARY KEY (course_name)); create table student_course_registrations (student_id varchar, course_id varchar, PRIMARY KEY (student_id))
select t1.student_id, t2.course_name from student_course_registrations as t1 join courses as t2 on t1.course_id = t2.course_id