SQL to determine if a non-attendance is a “DROPOUT”

Yes… Thank you.

After weeks of trying to resolve this myself, I finally realised the power of forums.