LEAD

1
SELECT
2
  event_name,
3
  event_date,
4
  LEAD(event_name) OVER (ORDER BY event_date) as next_event,
5
  LEAD(event_date) OVER (ORDER BY event_date) as next_event_date
6
FROM events;

1
SELECT
2
  event_name,
3
  start_time,
4
  LEAD(start_time) OVER (ORDER BY start_time) as next_start,
5
  DATEDIFF('MINUTE', start_time,
6
    LEAD(start_time) OVER (ORDER BY start_time)
7
  ) as duration_minutes
8
FROM events;

1
SELECT
2
  user_id,
3
  action,
4
  action_time,
5
  LEAD(action, 1, 'SESSION_END') OVER (
6
    PARTITION BY user_id
7
    ORDER BY action_time
8
  ) as next_action
9
FROM user_actions;