Advertisement
Guest User

Untitled

a guest
Sep 15th, 2019
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. rockset> select count(*) as cancelled_requests
  2. from "oakland-call-center"
  3. where STATUS = 'CANCEL'
  4. and SOURCE = 'SeeClickFix'
  5. and PARSE_DATETIME_ISO8601(DATETIMEINIT) > CURRENT_DATETIME() - DAYS(3);
  6. +----------------------+
  7. | cancelled_requests |
  8. |----------------------|
  9. | 44 |
  10. +----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement