SQL - Table Relationships
Given tables
What will this query return?
Student, Course, and junction table StudentCourse with data:Student: (1, 'Alice'), (2, 'Bob')Course: (101, 'Math'), (102, 'Science')StudentCourse: (1, 101), (1, 102), (2, 101)What will this query return?
SELECT s.Name, c.Name FROM Student s JOIN StudentCourse sc ON s.ID = sc.StudentID JOIN Course c ON c.ID = sc.CourseID WHERE c.Name = 'Math';
