0xHaM-dFlow Users Grouped by Number of Transactions
    Updated 2022-07-19
    with tab1 as (
    select
    proposer,
    count(*) as transactions

    from flow.core.fact_transactions
    group by 1
    Order by 2 DESC
    )

    select
    CASE
    when transactions < 2 then 'Less than 2 Transactions'
    when transactions between 2 and 5 then 'Between 2 and 5 Transactions'
    when transactions between 5 and 7 then 'Between 5 and 7 Transactions'
    Else 'Greater than 7 Transactions'
    END as group1,
    count(*)


    from tab1
    group by 1
    Run a query to Download Data