LEAD

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

1
SELECT
2
  user_id,
3
  event_time,
4
  event_type,
5
  LEAD(event_time) OVER (PARTITION BY user_id ORDER BY event_time) - event_time as time_to_next
6
FROM user_events;

1
SELECT
2
  order_id,
3
  order_date,
4
  LEAD(order_date) OVER (PARTITION BY customer_id ORDER BY order_date) as next_order_date,
5
  DATE_DIFF('day', order_date,
6
    LEAD(order_date) OVER (PARTITION BY customer_id ORDER BY order_date)) as days_to_next_order
7
FROM orders;