Get the Second Most Recent Activity

Given a table of timestamped activities, return each user's second-most-recent activity. The challenge is to correctly rank events by time per user and handle edge cases like ties, users with fewer than two records, and scalability on large datasets.