payer

,case

when payer='0x1b65c33d7a352c61' then 'CricketMoments'

when payer='0x6f649aee955bef6d' then 'RCRDSHP'

when payer='0x18eb4ee6b3c026d2' then 'NBA TopShot'

when payer='0x94bb84386cfc3b5d' then 'Everbloom'

when payer='0x55ad22f01ef568a1' then 'Blocto'

when payer='0xecfad18ba9582d4f' then 'Joyride'

when payer='0x9b00972a3ecb364b' then 'Seussibles'

else payer

end as payer_name

,count(DISTINCT t.tx_id) as tx_count

,sum(EVENT_DATA:amount) as amount

from flow.core.fact_transactions t

join flow.core.fact_events e on e.tx_id = t.tx_id

where t.block_timestamp::date >= CURRENT_DATE -30

and AUTHORIZERS[0] != payer

and t.TX_SUCCEEDED=true

and EVENT_TYPE='TokensWithdrawn'

group by 1,2

order by tx_count DESC