count(distinct(tx_id)) as purchase_count

from solana.core.fact_nft_sales a

join solana.core.dim_labels b on a.mint = b.address

where address_name ilike 'Blockasset Legends%'

and succeeded = 'TRUE'

group by 1)

select case

when purchase_count = 1 then 'Purchased Once'

when purchase_count > 1 and purchase_count <= 5 then 'Purchased 2 to 5'

when purchase_count > 5 and purchase_count <= 10 then 'Purchased 6 to 10'

else 'More than 10 Purchases'

end as purchases,

count(distinct(purchaser)) as wallet_count,

(select avg(purchase_count) from table_1) as avg_purchase_count

from table_1

group by 1