count(distinct purchaser) as "Purchasers Count", count(distinct seller) as "Sellers Count", count(distinct token_id) as "NFTs Count",

count(distinct tx_id) as "Sales Count", sum(sales_amount)/pow(10,6) as "Sales Volume", case

when "Date"<'2023-01-01' then 'Year 2022'

else 'Year 2023'

end as "Year"

from terra.core.fact_nft_sales

where tx_succeeded='TRUE' and block_timestamp::date>='2022-12-01' and currency='uluna'

group by 1

order by 1)

select "Year", round(avg("Collections Count")) as "Average Collections Count", round(avg("Purchasers Count")) as "Average Purchasers Count",

round(avg("Sellers Count")) as "Average Sellers Count", round(avg("NFTs Count")) as "Average NFTs Count",

round(avg("Sales Count")) as "Average Sales Count", avg("Sales Volume") as "Average Sales Volume"

, round(median("Collections Count")) as "Median Collections Count", round(median("Purchasers Count")) as "Median Purchasers Count",

round(median("Sellers Count")) as "Median Sellers Count", round(median("NFTs Count")) as "Median NFTs Count",

round(median("Sales Count")) as "Median Sales Count", median("Sales Volume") as "Median Sales Volume"

from tab1

group by 1