SocioCrypto2022 at a glance
    Updated 2023-01-25
    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

    Run a query to Download Data