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'

else 'Others'

END AS "Payer",

count(distinct tx_id) as "Transactions"

from flow.core.fact_transactions x

where tx_succeeded='true' and trunc(block_timestamp,'month')<'2023-11-01'

group by 1

order by 2 desc