SELECT S.StudentID, S.Name, E.CourseID FROM Student S INNER JOIN Enrollment E ON S.StudentID = E.StudentID; SELECT S.Name, E.Semester FROM Student S INNER JOIN Enrollment E ON S.StudentID = ...