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

when payer ='0x319e67f2ef9d937f' then 'Lilico Wallet'

when payer ='0x55ad22f01ef568a1' then 'Blocto'

else 'Other wallets' end as wallet_type,

count (distinct tx_id) as tx_num,

count(distinct proposer) as wallet_num

from flow.core.fact_transactions

where payer !=proposer and TX_SUCCEEDED= 'true'

and proposer not in ('0x18eb4ee6b3c026d2','0x0ebf23858d5497f6','0x55ad22f01ef568a1')

and tx_id in (select tx_id from flow.core.ez_nft_sales)

group by 1