ngxuan885The Rise of DeGods: Mouth
    Updated 2022-04-02
    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
    Run a query to Download Data