CASE WHEN payer = '0x18eb4ee6b3c026d2' THEN 'Dapper'

WHEN payer = '0xecfad18ba9582d4f' THEN 'Joyride'

WHEN payer = '0x55ad22f01ef568a1' THEN 'Blocto'

WHEN payer = '0x8234007b36f8113c' THEN 'Monsoon'

WHEN payer = '0x1b65c33d7a352c61' THEN 'CricketMoments'

WHEN payer = '0x6f649aee955bef6d' THEN 'RCRDSHP'

WHEN payer = '0x4bbff461fa8f6192' THEN 'Fantastec'

WHEN payer = '0x93615d25d14fa337' THEN 'ChainMonsters'

WHEN payer = '0x94bb84386cfc3b5d' THEN 'Everbloom'

WHEN payer = '0x39e42c67cc851cfb' THEN 'Lilico'

END AS "Payer",

COUNT(DISTINCT(x.proposer)) AS "Number of Users",

COUNT(x.tx_id) AS "Number of Transactions",

sum(EVENT_DATA:amount) AS Volume,

Volume / "Number of Transactions" as "Average volume per transaction",

Volume / "Number of Users" as "Average volume per user"

FROM flow.core.fact_transactions x JOIN flow.core.fact_events y ON x.tx_id = y.tx_id

WHERE x.TX_SUCCEEDED = 'TRUE'

AND y.event_type = 'TokensWithdrawn'

AND (payer = '0x18eb4ee6b3c026d2'

OR payer = '0xecfad18ba9582d4f'

OR payer = '0x55ad22f01ef568a1'

OR payer = '0x8234007b36f8113c'

OR payer = '0x1b65c33d7a352c61'

OR payer = '0x6f649aee955bef6d'

OR payer = '0x4bbff461fa8f6192'

OR payer = '0x93615d25d14fa337'

OR payer = '0x94bb84386cfc3b5d'

OR payer = '0x39e42c67cc851cfb')

GROUP BY 1