Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/cancelled_reqs.sql

Created September 4, 2019 18:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kleong/f93697c840f9820943052e198823e215 to your computer and use it in GitHub Desktop.
Save kleong/f93697c840f9820943052e198823e215 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cancelled_reqs.sql
rockset> select count(*) as cancelled_requests
from "oakland-call-center"
where STATUS = 'CANCEL'
and SOURCE = 'SeeClickFix'
and PARSE_DATETIME_ISO8601(DATETIMEINIT) > CURRENT_DATETIME() - DAYS(3);
+----------------------+
| cancelled_requests |
|----------------------|
| 44 |
+----------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment