author,

org,

repo,

count(*) as no_of_actions,

count(distinct date_trunc('day', updatedat)) as no_of_days_active

from near.beta.github_activity

group by 1,2,3

order by 4 desc