Skip to content

Instantly share code, notes, and snippets.

@Scarysize

Scarysize/calendar-query.sql

Last active December 5, 2017 14:17
Show Gist options
  • Save Scarysize/5e2f9f3eda76b22266aa8e9226393e15 to your computer and use it in GitHub Desktop.
Save Scarysize/5e2f9f3eda76b22266aa8e9226393e15 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
calendar-query.sql
-- get all trips happening on a regular monday
SELECT
trips.trip_id
FROM
trips,
calendar
WHERE
calendar.monday == 1
AND
trips.service_id == calendar.service_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment