case when date >= '2023-01-14' then 'After Announcement' else 'Before Announcement' end as timeframe,

count(DISTINCT tx_id) as sales,

count(DISTINCT purchaser) as purchasers,

count(DISTINCT seller) as sellers,

sum(sales_amount/pow(10,decimals)) as total_volume

from terra.core.fact_nft_sales

where tx_succeeded = TRUE

and date>= '2023-01-07' and date<= '2023-01-21'

group by 1,2