kiacryptoHolders distribution
    Updated 2022-06-22
    with holders as (
    select nft_to_address as address, '+1' as hold_count
    from ethereum.core.ez_nft_transfers
    where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
    union all

    select nft_from_address as address, '-1' as hold_count
    from ethereum.core.ez_nft_transfers
    where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
    ),
    hold_count as (
    select address, sum(hold_count) as NFTs_count
    from holders
    group by 1 having NFTs_count > 0
    )

    select case
    when NFTs_count = 1 then '1'
    when NFTs_count = 2 then '2'
    when NFTs_count > 2 and NFTs_count <= 4 then '3 - 4'
    when NFTs_count > 4 and NFTs_count <= 8 then '5 - 8'
    when NFTs_count > 8 and NFTs_count <= 16 then '9 - 16'
    when NFTs_count > 16 and NFTs_count <= 32 then '17 - 32' end as dis, count(*)
    from hold_count
    group by 1
    Run a query to Download Data