SELECT

contract_address,

SUM(CASE

WHEN topic_0 IN (

'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62',

'0x4a39dc06d4c0dbc64b70b5eb2aa10c99d1887e3f0adf967c6fbbfb89c4a79e11'

)

THEN 1 ELSE 0

END) AS erc1155_transfers,

SUM(CASE

WHEN topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND ARRAY_SIZE(topics) = 4

THEN 1 ELSE 0

END) AS erc721_transfers

FROM monad.testnet.fact_event_logs

WHERE block_timestamp >= '2025-02-19'

AND contract_address IS NOT NULL

GROUP BY contract_address

)

SELECT

'Total NFTs' AS token_type, COUNT(DISTINCT CASE

WHEN erc721_transfers > 0 OR erc1155_transfers > 0 THEN contract_address

ELSE NULL

END) AS contract_count

FROM contract_classification;