departure_board.sql

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