count (distinct tx_hash) as order_placed,

count(distinct '0x' || SUBSTR(topics[1], 27)) AS buyer,

sum(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 ) AS amount,

FROM mezo.testnet.fact_event_logs

WHERE CONTRACT_ADDRESS = LOWER('0x637e22A1EBbca50EA2d34027c238317fD10003eB')

AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

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