headitmanagerDistribution on Ethereum
    Updated 2022-10-15
    with datas as (select NFT_ADDRESS as nft , sum(PRICE) as eth_value from ethereum.core.ez_nft_sales
    group by nft)

    select count(case when eth_value = 0.01 then 1 else null end) , ' sum of nft sales = 0.01' from datas
    union all
    select count(case when eth_value = 0.1 then 1 else null end) , ' sum of nft sales = 0.1' from datas
    union all
    select count(case when eth_value = 1 then 1 else null end) , ' sum of nft sales = 1' from datas
    union all
    select count(case when eth_value < 0.01 then 1 else null end) , ' sum of nft sales < 0.01' from datas
    union all
    select count(case when eth_value > 0.01 and eth_value < 0.1 then 1 else null end) , ' sum of nft sales > 0.01 and < 0.1' from datas
    union all
    select count(case when eth_value > 0.1 and eth_value < 1 then 1 else null end) , ' sum of nft sales > 0.1 and < 0.01' from datas
    union all
    select count(case when eth_value > 1 then 1 else null end) , ' sum of nft sales > 1' from datas

    Run a query to Download Data