Tour leg timetable
Ahead of the season, the team needs a unified timeline of every transit leg: origin, destination, departure time, and arrival time. Return these four fields for every tour leg and sort the result by departure time.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| time_in | town_to | time_out | town_from |
|---|---|---|---|
| 2024-01-12 11:30:00 | Hamburg | 2024-01-12 07:15:00 | Prague |
| 2024-01-13 16:00:00 | Milan | 2024-01-13 09:30:00 | Zurich |
| 2024-01-14 20:45:00 | Oslo | 2024-01-14 13:00:00 | Helsinki |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid