Self-Join for Telemetry Sequences

Write a query using a self-join to track sequential events in a vehicle telemetry log. Return each event with the next chronological event for the same vehicle and the elapsed time between them. An event is sequential only when no other event for that vehicle occurs between the two events.

Output

1. One row per event that has a following event.
2. Columns: vehicle_id, current_event_id, current_event_type, current_event_time, next_event_id, next_event_type, next_event_time, and seconds_to_next.
3. Order by vehicle_id, current_event_time, and current_event_id ascending.