Here is what I had:

This is where I started to write the case statement.

Select top 5

A.ApplicationId,

A.Id as ExamId,

DateOfExam,

B.DateStartEffectiveEligibility,

/*'DateEffectiveFailed' = CASE

        WHEN NumOfApps = 1...