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
)