Select students.Student_ID, First_Name, Last_Name, Enrollment_Year, Degree_ID, Department, [Description]
From Students students Full Join StudentDegrees studentDegrees On students.Student_ID = studentDegrees.Student_ID
Full Join [Degrees] [degrees] on studentDegrees.Degree = [degrees].Degree_ID
Where students.Student_ID = 10008
Order By Department;