G2A Many GEOs
SHARE
TWEET

event_count.sql

Dyrcona Dec 26th, 2019 81 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select date(add_time) as "Date",
  2. sum(case when event_def = 6 then 1 else 0 end) as "2-Day Courtesy Notice",
  3. sum(case when event_def = 124 then 1 else 0 end) as "Auto-renewal",
  4. count(*) as "All Events"
  5. from action_trigger.event
  6. group by 1
  7. order by date(add_time)
RAW Paste Data
Ledger Nano X - The secure hardware wallet
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