SELECT

COUNT(DISTINCT TX_HASH) AS tx_count,

NFT_TO_ADDRESS

FROM base.nft.ez_nft_transfers

WHERE NFT_address = lower('0x03c4738Ee98aE44591e1A4A4F3CaB6641d95DD9a')

AND NFT_from_address = '0x0000000000000000000000000000000000000000'

AND block_timestamp >= '2024-08-20'

GROUP BY 2

CASE

WHEN tx_count = 1 THEN '1'

WHEN tx_count = 2 THEN '2'

WHEN tx_count BETWEEN 3 AND 5 THEN '3 to 5'

WHEN tx_count BETWEEN 6 AND 10 THEN '6 to 10'

WHEN tx_count BETWEEN 11 AND 25 THEN '11 to 25'

WHEN tx_count BETWEEN 26 AND 50 THEN '26 to 50'

WHEN tx_count BETWEEN 51 AND 100 THEN '51 to 100'

WHEN tx_count BETWEEN 101 AND 250 THEN '101 to 250'

WHEN tx_count BETWEEN 251 AND 500 THEN '251 to 500'

ELSE 'More than 500'

END AS "MINTED BASENAMES ",

COUNT(DISTINCT a.NFT_TO_ADDRESS) AS "TOTAL WALLETS"

FROM minted_names a

GROUP BY 1

ORDER BY 2 DESC