flipside

    Distribbution of Repositories Based on the Forks Count
    Eman-RazDistribbution of Repositories Based on the Forks Count
    Updated 2024-01-29
    with tab1 as (select repo_name as "Repo Name", data:forks_count as "Number of Forks"
    from near.core.fact_developer_activity
    where data:forks_count is not null)

    select "Number of Forks", count(distinct "Repo Name") as "Repo Count"
    from tab1
    group by 1

    Last run: about 1 year agoAuto-refreshes every 24 hours
    Number of Forks
    Repo Count
    1
    1
    		730
    2
    5
    		44
    3
    23
    		3
    4
    7
    		27
    5
    19
    		3
    6
    51
    		1
    7
    67
    		1
    8
    36
    		2
    9
    18
    		10
    10
    11
    		13
    11
    88
    		1
    12
    106
    		1
    13
    44
    		1
    14
    119
    		1
    15
    267
    		1
    16
    8
    		29
    17
    12
    		9
    18
    32
    		3
    19
    41
    		3
    20
    66
    		1
    89
    657B
    3s