- WITH users_grouped AS
- ( SELECT EXTRACT(DAY FROM creation_date) AS day_reg,
- COUNT(id) AS count_id
- FROM stackoverflow.users
- GROUP BY day_reg,id)
- SELECT *,
- SUM(count_id) OVER (PARTITION BY creation_date)
- FROM users_grouped
- WHERE EXTRACT(MONTH FROM creation_date) = 11
- AND EXTRACT(YEAR FROM creation_date) = 2008
- GROUP BY day_reg;
