gokcindistrubtion
    Updated 2022-09-09
    with tab1 as (
    select
    count(distinct(tx_from)) as users,
    sum(amount) as amount,
    avg(amount) as avg_amount,
    case when amount < 10 then 'Fish'
    when amount < 100 then 'Dolphin'
    when amount < 1000 then 'Shark'
    else 'Whale' end as tier
    FROM solana.core.fact_transfers
    where mint='DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
    group by tier
    )

    select *
    from tab1
    Run a query to Download Data