superflyUntitled Query
    Updated 2022-10-14
    with maintable as (select seller_address,count (distinct tx_hash) as Sales_Count,count (distinct tokenid) as Tokens_Count,
    sum (price_usd) as Total_USD_Volume from optimism.core.ez_nft_sales
    where nft_address = '0x52782699900df91b58ecd618e77847c5774dcd2e' and price_usd > 0
    group by 1)select case when Tokens_Count = 1 then '1 Token'
    when Tokens_Count > 1 and Tokens_Count <= 5 then '2 - 5 Tokens' when Tokens_Count > 5 and Tokens_Count <= 10 then '6 - 10 Tokens'
    else 'More Than 10 Tokens' end as type, count (distinct seller_address)
    from maintable group by 1 order by 2 desc
    Run a query to Download Data