with tab1 as (

select

purchaser,

mint,

sales_amount as bought_amount

from solana.core.fact_nft_sales

)

,

tab2 as (

select

Seller,

mint,

sales_amount as sold_amount

from solana.core.fact_nft_sales

)

, tab3 as (

select

purchaser,

sold_amount - bought_amount as net_profit

from tab1 left outer join tab2 on

purchaser = seller and tab1.mint = tab2.mint

where bought_amount is not null

and sold_amount is not null

)

select

avg(net_profit) as "Average Profit" ,

median(net_profit) as "Median Profit"

from tab3

where net_profit > 0