CASE

WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 100 THEN 'Taho x Mezo NFT'

WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 300 THEN 'Mezo Cap'

WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 700 THEN 'Everything on Bitcoin T-shirt'

WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 1300 THEN 'Owners Club Hoodie'

ELSE 'Unknown Item'

END AS item_purchased,

COUNT(DISTINCT tx_hash) AS sales,

COUNT(DISTINCT '0x' || SUBSTR(topics[1], 27)) AS total_buyers,

SUM(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18) AS total_amount -- Sum of amounts

mezo.testnet.fact_event_logs

CONTRACT_ADDRESS = LOWER('0x637e22A1EBbca50EA2d34027c238317fD10003eB')

AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND '0x' || SUBSTR(topics[2], 27) = '0xd6626dcca8aa760b227e02b2391aaaecf9371c5d'

GROUP BY

item_purchased

ORDER BY

total_amount DESC;