SELECT tx_hash, COUNT(TOKENID) AS mints

FROM arbitrum.nft.ez_nft_transfers

WHERE nft_address = '0x78072889ee4d7fe1a100c25296aabbea32e92bea'

AND event_type = 'mint'

AND block_timestamp >= '2024-09-09'

GROUP BY tx_hash

SELECT

COUNT(DISTINCT tx_hash) AS transaction,

CASE

WHEN mints = 1 THEN '1 NFT'

WHEN mints = 2 THEN '2 NFT'

WHEN mints = 3 THEN '3 NFT'

WHEN mints = 4 THEN '4 NFT'

WHEN mints = 5 THEN '5 NFT'

ELSE NULL

END AS amount_range

FROM ARBstylus

WHERE amount_range != ('')

GROUP BY amount_range