DATE_TRUNC('week', block_timestamp) AS week,

to_address,

CASE

WHEN to_address = LOWER('0xe397784960f814ba35c9ee0bc4c9dffdf86925f9') THEN 'Monsterra'

WHEN to_address = LOWER('0x483416eB3aFA601B9C6385f63CeC0C82B6aBf1fb') THEN 'CryptoBlades'

WHEN to_address = LOWER('0xe3b3f75f99da4ff26aa867ef70b48f8f6b2d4958') THEN 'MegaWeapon'

WHEN to_address = LOWER('0xef0cdae2ffeeefa539a244a16b3f46ba75b8c810') THEN 'GetFit Mining'

ELSE 'Unknown'

END AS project,

COUNT(DISTINCT from_address) AS "Total Wallets",

COUNT(DISTINCT tx_hash) AS "Total Transactions",

SUM(tx_fee) AS "Total Tx Fee (AVAX)"

avalanche.core.fact_transactions

to_address IN (

LOWER('0x483416eB3aFA601B9C6385f63CeC0C82B6aBf1fb'),

LOWER('0xe397784960f814ba35c9ee0bc4c9dffdf86925f9'),

LOWER('0xef0cdae2ffeeefa539a244a16b3f46ba75b8c810'),

LOWER('0xe3b3f75f99da4ff26aa867ef70b48f8f6b2d4958')

)

AND tx_succeeded = TRUE

GROUP BY week, to_address

ORDER BY week DESC, "Total Transactions" DESC;