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.
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.