distinct BUYER_ADDRESS as sender,

count(tx_hash) as no_transaction

from optimism.core.ez_nft_sales

where PLATFORM_NAME='quixotic'

and EVENT_TYPE='sale'

group by 1)

select

'Quix' as MARKETPLACES,

case

when no_transaction=1 then 'One time users'

when no_transaction>1 then 'More than 1 transaction'

end as buckets,

count(distinct sender) as count_users

from tb1

group by 1,2),

ME as (with tb1 as (select

distinct purchaser as sender,

MARKETPLACE,

count(tx_id) as no_transaction

from solana.core.fact_nft_sales

where marketplace ilike '%magic eden%'

and succeeded = TRUE

group by 1,2

select

'Magic Eden' as marketplaces,

case

when no_transaction=1 then 'One time users'

when no_transaction>1 then 'More than 1 transaction'

end as buckets,

count(distinct sender) as count_users

from tb1