WITH aprior_product_tag_dim AS (

select

FROM_ADDRESS as wallet

,'Exclusive LST User' as user_tag

,date(BLOCK_TIMESTAMP) as stat_date

from monad.testnet.fact_transactions

where TO_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')

group by 1,3

union all

select

TO_ADDRESS as wallet

,'Exclusive Faucet User' as user_tag

,date(BLOCK_TIMESTAMP) as stat_date

from monad.testnet.fact_transactions

where FROM_ADDRESS=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')

group by 1,3

),

base_user_dim as

SELECT

wallet,

CASE

WHEN COUNT(DISTINCT user_tag) > 1 THEN 'Both User Groups'

ELSE MAX(user_tag)

END as base_user_tag

,min(stat_date) as create_date

FROM aprior_product_tag_dim

GROUP BY wallet

),