case when payer ='0x39e42c67cc851cfb' then 'lilico'

when payer ='0x18eb4ee6b3c026d2' then 'Dapper'

when payer ='0x55ad22f01ef568a1' then 'Blocto'

else payer end as Payer_Name,

count (distinct a.tx_id) as TX_Count,

count (distinct proposer) as Users_Count

from flow.core.fact_transactions a join flow.core.fact_events b on a.tx_id = b.tx_id

where EVENT_TYPE='TokensWithdrawn'

and a.TX_SUCCEEDED ilike 'true'

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

group by 1,2