SELECT TOKEN_METADATA:Mouth as Mouth,
sum(SALES_AMOUNT) as amount
from solana.fact_nft_sales s
join solana.dim_nft_metadata d
on d.mint = s.mint
where d.PROJECT_NAME = 'DeGods'
and s.MARKETPLACE in ('magic eden v1','magic eden v2')
and s.SUCCEEDED = TRUE
and BLOCK_TIMESTAMP::date >= '2022-01-01'
GROUP by 1 order by 2 DESC