(select BLOCK_TIMESTAMP as date, MINT as NFT_ID, PURCHASER as BUYER, SELLER

from solana.core.fact_nft_sales

where SUCCEEDED=true and BLOCK_TIMESTAMP>='2022-04-20')

select date_trunc('week',DATE1) as date, tag, count(*) as buyer

from

(select a.date as date1, a.NFT_ID,

a.BUYER as BUYER1, a.SELLER as SELLER1, b.date as date2,

b.BUYER as BUYER2, b.SELLER as SELLER2, timediff(week,date1, date2) as week_diff,

CASE

when week_diff=0 then 'Buyer Sold Within A Week'

else 'Buyer Did Not Sell Within A Week'

end as tag

from sol_sales a

left join sol_sales b

on a.NFT_ID=b.NFT_ID and a.BUYER=b.SELLER and a.date<b.date

group by date, tag

order by tag