Technical Screen

Merging Overlapping Vehicle-Run Intervals in SQL and Python

NuroData Scientist · Technical Screen · Jul 2025

Dataset description The dataset had several fields: set id, run id, start time, end time, and set number. The set ids ran from 1 to 6 and represented different recorded segments from autonomous-vehicle sessions. For example, set 1 was about 30 seconds long, set 2 was 23 seconds, set 3 was 19 seconds, and so on. The run id identified the trip. It used a time-string format such as 20250101_122334,…

Shared by a candidate · reported Jul 2025. Interview formats change; use it as a guide, not a script.