Ali3NWhales vs NonWhales
    Updated 2022-11-17
    with Maintable as (
    select tx_from,
    sum (amount) as Volume
    from solana.core.fact_transfers t1 join solana.core.dim_labels t2 on t1.tx_to = t2.address
    where label != 'solana'
    and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and label_type not in ('nft','token')
    and block_timestamp >= CURRENT_DATE - 93
    group by 1)

    select case when Volume > 100000 then 'Whales'
    else 'Non-Whales' end as type,
    count (distinct tx_from)
    from Maintable
    group by 1
    order by 2 desc
    Run a query to Download Data