select

TX_HASH as "transactions",

count (tokenid) as "nfts"

from ethereum.core.ez_nft_sales

where AGGREGATOR_NAME ='Blur'

and EVENT_TYPE = 'sale'

and BLOCK_TIMESTAMP >= CURRENT_DATE - 7

group by 1)

select

WHEN "nfts" =1 then'only 1 NFT'

WHEN "nfts" >= 2 AND "nfts"< 5 THEN '2-5 NFTs'

WHEN "nfts" >= 5 AND "nfts"< 10 THEN '5-10 NFTs'

WHEN "nfts" >= 10 AND "nfts"< 20 THEN '10-20 NFTs'

WHEN "nfts" >= 20 AND "nfts"<50 THEN '20-50 NFTs'

WHEN "nfts" >= 50 then 'More than 50 NFTs'

END as status,

COUNT(DISTINCT "transactions") as "num_transactions"

from base

where status is not null

group by 1