john-adamUntitled Query
    Updated 2022-10-16
    with total_nft_ethereum as (select count(distinct nft_address)
    from ethereum.core.ez_nft_sales)
    , total_nft_ethereum as (select count(distinct nft_address)
    from ethereum.core.ez_nft_sales)
    , ethereum_allnft as (select sum(price) as s , nft_address
    from ethereum.core.ez_nft_sales
    group by 2
    order by 1 desc)
    , ethereum_allnft as (select sum(price) as s , nft_address
    from ethereum.core.ez_nft_sales
    group by 2
    having s < 100
    order by 1 desc)
    select * from ethereum_allnft
    Run a query to Download Data