select block_timestamp, tx_id,SELLER from solana.core.fact_nft_sales

where mint in (select mint from solana.core.dim_nft_metadata where project_name = 'ABC' )

and block_timestamp > current_date - interval ' 2 month'

),

underworld_sellers as

select block_timestamp,tx_id,seller from solana.core.fact_nft_sales

where mint in ( select address from solana.core.dim_labels where address_name='underworld_nft' )

),

temp as

select u.* from abc_sellers a inner join

underworld_sellers u

on (a.seller=u.seller and a.block_timestamp<u.block_timestamp)

select block_timestamp::date as "date", count(distinct tx_id) from temp group by 1