Dyrcona Dec 26th, 2019 81 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select date(add_time) as "Date",
- sum(case when event_def = 6 then 1 else 0 end) as "2-Day Courtesy Notice",
- sum(case when event_def = 124 then 1 else 0 end) as "Auto-renewal",
- count(*) as "All Events"
- from action_trigger.event
- group by 1
- order by date(add_time)
RAW Paste Data