Eman-RazDistribution of Users By Number of GM Txn
    Updated 2025-03-14
    with tab1 as (select from_address as user, count(distinct tx_hash) as "Txns Count"
    from ink.core.fact_transactions
    where to_address='0x9f500d075118272b3564ac6ef2c70a9067fd2d3f'
    and tx_succeeded='TRUE' and (origin_function_signature='0xe884624b' -- GM_to_a_Fren
    or origin_function_signature='0xc0129d43') -- GM
    group by 1)

    select "Txns Count", count(distinct user) as "Number of Users"
    from tab1
    group by 1
    order by 1