I currently have this
SELECT PersonId, FirstName, LastName, Mbr#, CONVERT(varchar, Birthdate, 101) AS Birthdate, Age, MAX(CONVERT(varchar, TestDate, 101)) AS LastTestDate, TestType,
TestTrack, MAX(SkateTestLevelRank) AS HighestSkateTstLevel, Completed
WHERE (Passed = 1)
to display the highest skated level.
However when the TestType = "Dance" it needs to be marked as Completed.
How do you add, I'm thinking, an IF / CASE WHEN statement to display that correctly?