(WITH database AS (

SELECT

a.BLOCK_TIMESTAMP,

a.TX_HASH,

a.ORIGIN_FROM_ADDRESS AS "Staker",

b.value AS "$MON Staked",

CAST(ethereum.public.udf_hex_to_int(data) AS decimal) / 1e18 AS "$sMON Received",

b.tx_fee AS "Fee ($MON)"

FROM

monad.testnet.fact_event_logs a

JOIN monad.testnet.fact_transactions b ON a.tx_hash = b.tx_hash

WHERE

a.CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'

AND a.ORIGIN_TO_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'

AND a.ORIGIN_FUNCTION_SIGNATURE = '0x3a4b66f1'

AND a.TX_SUCCEEDED = 'TRUE'

AND a.BLOCK_TIMESTAMP > '2025-02-18 00:00:00.000'

"Staker",

sum ("$MON Staked") as "Total $MON Staked",

count (distinct TX_HASH) as "Stake tx"

from database

group by 1

SELECT

case

when "Total $MON Staked" < 0.1 then 'Tier1: Less Than 0.1 $MON'

when "Total $MON Staked" >= 0.1 and "Total $MON Staked" < 0.5 then 'Tier2: 0.1-0.5 $MON'

when "Total $MON Staked" >= 0.5 and "Total $MON Staked" < 1 then 'Tier3: 0.5-1 $MON'

when "Total $MON Staked" >= 1 and "Total $MON Staked" < 10 then 'Tier4: 1-10 $MON'

when "Total $MON Staked" >= 10 and "Total $MON Staked" < 100 then 'Tier5: 10-100 $MON'

when "Total $MON Staked" >= 100 then 'Tier6: more than 100 $MON' end as "Tier",