Many to Many Join — Solution & ExplanationProblems / Many to Many Join / EditorialApproach

Start from enrollments as the base table.

JOIN to students on student_id to get student names.

JOIN to courses on course_id to get course details.

Select the required columns and order.

Key InsightMany-to-many relationships require a junction (bridge) table. Each row in enrollments represents one student-course pair. By joining through it, you resolve the M:N relationship into a flat result. The junction table is the natural starting point for the query.Hints

Start from the junction table (enrollments) and join outward to both entity tables.

Each enrollment row links one student to one course — the M:N relationship is in the junction table.

A student can have multiple courses and a course can have multiple students.

Solve Many to Many Join yourself →