proposer,

case when payer ='0x18eb4ee6b3c026d2' then 'Dapper'

when payer='0x319e67f2ef9d937f' then 'Lilico'

when payer = '0x4bbff461fa8f6192' then 'Fantastec'

when payer ='0x55ad22f01ef568a1' then 'Blocto'

when payer= '0x1b65c33d7a352c61' then 'FanCraze'

end as wallets

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.block_timestamp > '2022-01-01'

and a.TX_SUCCEEDED='TRUE'

group by 1,2

having wallets is not null)

wallets,

date_trunc(day,a.block_timestamp) as date,

count (distinct tx_id) as sale_transactions,

count (distinct BUYER) as nft_buyers

from flow.core.ez_nft_sales a join topwallets b on a.buyer = b.proposer

where a.block_timestamp > '2022-01-01'

group by 1,2