Type the modern three-table inner join (the shape you will write on the exam):
Type the modern three-table inner join (the shape you will write on the exam):
Answer
SELECT st.name, c.code FROM registrations r JOIN students st ON st.student_id = r.student_id JOIN sections s ON s.section_id = r.section_id JOIN courses c ON c.course_id = s.course_id;
Each JOIN names a table and the ON condition that links it to what is already joined — three tables, two ON conditions reaching them from registrations.