SocioCryptoAuthor - average
    Updated 2023-01-26
    SELECT avg(n_pull_requests),
    mode(n_pull_requests),
    median(n_pull_requests)
    FROM (
    SELECT author,
    count(DISTINCT id) as n_pull_requests
    FROM near.beta.github_activity
    WHERE date_trunc('day',closedat) between '2022-01-01' AND '2022-12-31'
    GROUP BY author
    )
    Run a query to Download Data