select School.SchoolID,Student.StudentNamefrom Student left join Class on Student.StudentId = Class.Student left join School on Class.ClassId = School.ClassId
