/departure_board.sql
Created Feb 8, 2017
| SELECT | |
| stops.stop_name | |
| , stop_times.departure_time_secs / 3600 AS departure_time_hours | |
| , (stop_times.departure_time_secs / 60) - ((stop_times.departure_time_secs / 3600) * 60) AS departure_time_mins | |
| , trips.trip_headsign | |
| , routes.route_short_name | |
| , calendars.monday | |
| , calendars.tuesday | |
| , calendars.wednesday | |
| , calendars.thursday | |
| , calendars.friday | |
| , calendars.saturday | |
| , calendars.sunday | |
| FROM stops | |
| JOIN stop_times ON stop_times.stop_id = stops.id | |
| JOIN trips ON trips.id = stop_times.trip_id | |
| JOIN routes ON routes.id = trips.route_id | |
| JOIN calendars ON calendars.service_id = trips.service_id | |
| WHERE | |
| stops.stop_id LIKE '%38587' | |
| AND calendars.wednesday = 1 | |
| ORDER BY stop_times.departure_time_secs |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment