with main_tab as (
select
nft_to_address,
count (distinct tx_hash) as tx_count,
count (distinct tokenid) as minted_tokens,
sum (mint_price_usd) as Volume
from ethereum.core.ez_nft_mints
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
group by 1)
select
count (distinct nft_to_address),
case
when minted_tokens = 1 then 'Minted 1 Token'
when minted_tokens = 2 then 'Minted 2 Tokens'
when minted_tokens = 3 then 'Minted 3 Tokens'
when minted_tokens = 4 then 'Minted 4 Tokens'
when minted_tokens = 5 then 'Minted 5 Tokens'
else 'Minted More Than 5 Tokens'
end as type
from main_tab
group by 2
order by 1 desc