Mine

select s.sid, s.name, r.rid, r.rdate, c.name, s.status from student as s 
INNER JOIN registration as r ON s.sid=r.sid
INNER JOIN student_course_interests as sc ON s.sid=sc.sid
INNER JOIN course as c ON c.cid=sc.cid;