from solana.core.fact_nft_sales

where marketplace in ('yawww','solanart'))

select date_trunc('day', block_timestamp) as dt, count(distinct tx_id) as num_txs, count(distinct purchaser) as num_buyers, 'Non 0% royalty marketplace' as type_user

from solana.core.fact_nft_sales

where marketplace in ('magic eden v1','magic eden v2')

and block_timestamp::date >= current_date-90 and block_timestamp::date != current_date

and purchaser not in (select purchaser from user_choice_royalty)

group by 1

union all

select date_trunc('day', block_timestamp) as dt, count(distinct tx_id) as num_txs, count(distinct purchaser) as num_buyers, '0% royalty marketplace' as type_user

from solana.core.fact_nft_sales

where marketplace in ('yawww','solanart')

and block_timestamp::date >= current_date-90 and block_timestamp::date != current_date

group by 1