Ok. How about now? 🙂
Select a.StudentID, a.StudentName
From Students a
Inner join Registrations b on a.StudentID = b.StudentID
Where a.StudentStatus = ‘Active’
And b.RegistrationStatus not in (select RegistrationStatus
From Registrations
Where  RegistrationStatus = ‘Active’
And RegistrationDate >...