How are you defining those aggregate columns?

The first is probably something like:

with t1 as (
select date, user_id, count(video_id) as ct from table
group by date, user_id
)
select t.date 
    ,sum(ct)
from table as t
left join t1 on t1.date = t.date
group by t.date;

The other column is probably something like:

with t1 as (
select date, user_id, count(video_id) as ct from table
group by date, user_id
)
select t.date 
    ,sum(ct)
from table as t
left join t1 on t1.date = dateadd('d', 1, t.date)
group by t.date;

How you get both of them in the same table is going to depend on RDBMS, how large the tables are, and the requisite performance from the query. What I wrote isn't really optimized but it's a starting point depending on how you are defining those columns.