Moennnrrrprr
    Updated 2023-01-27
    select

    count(distinct case when CLOSEDAT is null then id end) as n_open_prs,
    count(distinct case when CLOSEDAT is not null then id end) as n_closed_prs,
    n_open_prs + n_closed_prs as tot_prs,
    100 * n_open_prs / tot_prs as open_pr_ratio,
    100 * n_closed_prs / tot_prs as closed_pr_ratio,
    tot_prs / count(distinct author) as opened_pr_p_dev,
    n_closed_prs / count(distinct author) as closed_pr_p_dev

    from near.beta.github_activity


    Run a query to Download Data