author,

count(DISTINCT date_trunc('month', createdat)) as time_active ,

Count (distinct id) as Total_PR

FROM near.beta.github_activity

GROUP BY 1

ORDER BY 2 DESC

LIMIT 20