date_trunc('month', updateda) as date,

count(distinct id) as no_of_actions,

sum(no_of_actions) over (order by date) as cum_no_of_actions,

count(distinct author) as no_of_developers,

count(distinct org) as no_of_organisations,

count(distinct repo) as no_of_repositories

from near.beta.github_activity

group by 1

order by 1