date_trunc('Month', Min_D) as date,

"Wallet Name",

count(distinct proposer) as "# NEw Users"

from (

select

proposer,

case

when payer = '0x39e42c67cc851cfb' then 'lilico'

when payer = '0x55ad22f01ef568a1' then 'Blocto'

when payer = '0x18eb4ee6b3c026d2' then 'Dapper'

end as "Wallet Name",

min(BLOCK_TIMESTAMP) as Min_D

from flow.core.fact_transactions

where TX_SUCCEEDED = 'TRUE'

and payer in ('0x39e42c67cc851cfb', '0x55ad22f01ef568a1', '0x18eb4ee6b3c026d2')

group by 1,2

)

group by 1,2