Pro exercise

Unknown times never win

Keep the latest status per account. Some rows have no usable timestamp; they may only survive when an account has no timed row at all. Be explicit about where missing values sort.

deduplication
NULL ordering
timestamps