WITH mint_events AS (

SELECT

tx_hash,

origin_from_address,

'0x' || SUBSTR(topics[0], 27) AS event_signature,

'0x' || SUBSTR(topics[1], 27) AS from_address,

'0x' || SUBSTR(topics[2], 27) AS to_address,

ethereum.public.udf_hex_to_int(topics[3]) AS nft_id,

-- kaia.utils.udf_hex_to_int(data :: STRING) AS amount

FROM kaia.core.fact_event_logs

WHERE

contract_address = LOWER('0xd339c2c302221ac56609a1f2bdfbe801fe78647e')

AND '0x' || SUBSTR(topics[1], 27) = '0x0000000000000000000000000000000000000000'

SELECT

COUNT(tx_hash) AS total_mints,

COUNT(DISTINCT origin_from_address) AS unique_minters,

COUNT(DISTINCT nft_id) AS total_unique_nfts

FROM mint_events;