distinct purchaser as uniqwl,

sum(sales_amount) as volume_sale

from solana.fact_nft_sales

where block_timestamp >= '2022-01-01' and SUCCEEDED='TRUE'

and mint in(select mint

from solana.dim_nft_metadata where CONTRACT_NAME='DeGods')

group by 1 order by 2 desc