Tour Departures in a Time Window
The tour coordinator needs a list of tour legs that departed on January 15, 2024 between 10:00 and 14:00 inclusive — to cross-check driver schedules. Output those tour legs with all of their fields.
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.
| id | band_id | time_in | town_to | time_out | town_from | venue_type |
|---|---|---|---|---|---|---|
| 7 | 3 | 2024-01-15 18:45:00 | Lyon | 2024-01-15 10:30:00 | Vienna | Arena |
| 21 | 2 | 2024-01-15 19:15:00 | Madrid | 2024-01-15 12:15:00 | Lisbon | Club |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in