COALESCE snapshot date

[TommyLiang99]

cumulative-table-design/queries/active_users_cumulated_populate.sql

Line 51 in 7177daa

t.snapshot_date

Don't we need to coalesce the snapshot date as well?
What happens if the user appear on day 1 and day 3 but not on day 2. How will we able to retrieve its activity array on day 2 if t.snapshot_date will be null on day 2, so it will be null in the table.

[TommyLiang99]

Actually you need to do something like COALESCE(t.snapshot_date, y.snapshot_date + 1)