Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/num_reqs_by_source.sql

Created September 4, 2019 18:56
Show Gist options
  • Save kleong/f10f137f86883cf1ab9c0db61b5f4c98 to your computer and use it in GitHub Desktop.
Save kleong/f10f137f86883cf1ab9c0db61b5f4c98 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
num_reqs_by_source.sql
rockset> select SOURCE,
EXTRACT(DATE FROM PARSE_DATETIME_ISO8601(DATETIMEINIT)) as date
from "oakland-call-center"
where PARSE_DATETIME_ISO8601(DATETIMEINIT) > CURRENT_DATETIME() - DAYS(3)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment