Tour leg timetable
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. Your answer must use the same column names as this sample — alias them with AS if needed.
| town_from | town_to | time_out | time_in |
|---|---|---|---|
| Prague | Hamburg | 2024-01-12 07:15:00 | 2024-01-12 11:30:00 |
| Zurich | Milan | 2024-01-13 09:30:00 | 2024-01-13 16:00:00 |
| Helsinki | Oslo | 2024-01-14 13:00:00 | 2024-01-14 20:45:00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid