SELECT count(DISTINCT author) as n_authors,
count(DISTINCT id) as n_pull_requests,
count(DISTINCT repo) as n_repos,
COUNT(DISTINCT org) as n_org
FROM near.beta.github_activity
WHERE date_trunc('day',closedat) between '2022-01-01' AND '2022-12-31'
-- COLLABORATOR, CONTRIBUTOR, NONE, OWNER, MEMBER