SHARE
TWEET

Untitled

a guest Sep 15th, 2019 95 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. +----------------------+
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top