Your question is Build Driver Workflow Event Sequences. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are given event logs from a fleet workflow product and need to build a user-level event sequence for each driver in the Motive Driver App. Write a query that returns, for every non-null driver_id, each event in chronological order along with its sequence number, the previous event name and timestamp, the next event name and timestamp, and the minutes since the previous event. If two events have the same timestamp for a driver, break ties with event_id. Exclude rows where driver_id is null.
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event record ID |
| driver_id | INT | Driver identifier |
| event_name | VARCHAR(50) | Event captured in the Motive Driver App |
| event_ts | TIMESTAMP | Timestamp when the event occurred |
| surface | VARCHAR(50) | Product surface where the event occurred |
| trip_id | INT | Associated trip identifier, if applicable |