payer,

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",

a.proposer,

COUNT(DISTINCT(a.proposer)) AS "Number of users",

COUNT(a.tx_id) AS "Number of transactions"

FROM flow.core.fact_transactions a JOIN flow.core.fact_events b ON a.tx_id = b.tx_id

WHERE a.TX_SUCCEEDED = 'TRUE' AND (a.block_timestamp >= CURRENT_DATE - 30)

AND b.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, 2, 3, 4

ORDER BY 1 ASC, 2)

SELECT "Payer", COUNT(tx_id) AS "Number of sales", COUNT(DISTINCT(buyer)) AS "Number of NFT buyers", COUNT(DISTINCT(nft_id)) AS "Number of NFTs", COUNT(DISTINCT(nft_collection)) AS "Number of NFT Collections"

FROM flow.core.ez_nft_sales x JOIN wallets y ON x.buyer = y.proposer

WHERE block_timestamp >= CURRENT_DATE - 30

GROUP BY 1

ORDER BY 2 DESC