select student_name, GROUP_CONCAT(course_name SEPARATOR ',') as course_list
from student_course
group by student_name