Tour Timetable
Ahead of the season the team needs a unified timeline of every transit leg: from, to, departure and arrival times. Output these four fields for every tour leg, sorted 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 in