Problem 1369 · Hard

Get the Second Most Recent Activity

SQL walkthrough: rank each user’s non-overlapping activities by start date, keep the second most recent one (or the only one), and return its original columns.

Open the interactive visualisation