superflyUntitled Query
Updated 2022-10-14Copy Reference Fork
9
1
2
3
4
5
6
7
›
⌄
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