Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 |
- +----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement