drone-mostafaUntitled Query
    Updated 2022-08-28
    with Base as (select count(tx_hash) as TXN, count (DISTINCT seller_address) as sellers,
    count (DISTINCT buyer_address) as Buyers, sum(price_usd) as Sale_USD, avg(price_usd) as AVG_Sale_USD
    from ethereum.core.ez_nft_sales left outer join ethereum.core.dim_labels
    on nft_address = address where label like 'cryptopunks' and price_usd is not null order by sale_usd DESC limit 10 )


    select 'sellers' as type, sellers from Base UNION
    select 'Buyers' as type, Buyers from Base
    Run a query to Download Data