select date_trunc('week', new_date) as weekly, count(distinct tx_sender) as new_count, avg(new_count) over (order by weekly, weekly rows between 6 preceding and current row) as ma7_new_count,

sum(new_count) over (order by weekly) as cum_new_count from ramishoow group by 1 ), avg_info as ( select avg(new_count) as avg_new_count from info ) select * from ramishoow, avg_info