proposer,

when payer = '0x55ad22f01ef568a1' then 'Blocto'

when payer = '0x93615d25d14fa337' then 'ChainMonsters'

when payer = '0x1b65c33d7a352c61' then 'Cricket Moments'

when payer = '0x18eb4ee6b3c026d2' then 'Dapper'

when payer = '0x94bb84386cfc3b5d' then 'Everbloom'

when payer = '0x4bbff461fa8f6192' then 'Fantastec'

when payer = '0xecfad18ba9582d4f' then 'JoyRide'

when payer = '0x39e42c67cc851cfb' then 'Lilico'

when payer = '0x8234007b36f8113c' then 'Monsoon'

when payer = '0x6f649aee955bef6d' then 'RCRDSHP'

when payer = '0x9b00972a3ecb364b' then 'Seussibles'

end as wallet_name

from flow.core.fact_events a

join flow.core.fact_transactions b on a.tx_id = b.tx_id

where wallet_name is not null

and a.tx_succeeded = 'TRUE'

and event_type = 'TokensWithdrawn'

and payer in ('0x55ad22f01ef568a1',

'0x93615d25d14fa337',

'0x1b65c33d7a352c61',

'0x18eb4ee6b3c026d2',

'0x94bb84386cfc3b5d',

'0x4bbff461fa8f6192',

'0xecfad18ba9582d4f',

'0x39e42c67cc851cfb',

'0x8234007b36f8113c',

'0x6f649aee955bef6d',

'0x9b00972a3ecb364b')

group by 2,3),

table_2 as (select wallet_name,

count(distinct(proposer)) as nft_wallets

from table_1 a