Guest User

Untitled

a guest
Jun 10th, 2022
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. WITH events AS
  2. (SELECT DATE_TRUNC('month', event_time)::date AS event_month,
  3. COUNT(DISTINCT event_id) AS events_cnt
  4. FROM tools_shop.events e
  5. JOIN tools_shop.orders o ON e.user_id = o.user_id
  6. WHERE event_name = 'view_item'
  7. GROUP BY event_month)
  8. SELECT event_month,
  9. events_cnt,
  10. SUM(events_cnt) OVER (ORDER BY event_month) AS cum_sum
  11. FROM events;
Advertisement
Add Comment
Please, Sign In to add comment