from aptos.nft.ez_nft_sales

group by 2)

,

new as ( select DISTINCT buyer_address

from new_users

where date >= '2024-01-01')

,

final as ( select buyer_address,

count(DISTINCT block_timestamp::date) as days,

count(*) as sales,

count(DISTINCT project_name) as collections,

sum(total_price) as volume

from aptos.nft.ez_nft_sales

where block_timestamp >= '2024-01-01'

and buyer_address in (select buyer_address from new)

group by 1)

select count(DISTINCT buyer_address) as buyers,

case when volume <= 1 then 'a. <= 1 APT'

when volume <= 5 then 'b. 1-5 APT'

when volume <= 10 then 'c. 5-10 APT'

when volume <= 15 then 'd. 10-15 APT'

when volume <= 25 then 'e. 15-25 APT'

when volume <= 50 then 'f. 25-50 APT'

when volume <= 100 then 'g. 50-100 APT'

when volume > 100 then 'h. > 100 APT' end as breakdown

from final

group by 2