gayatridodmaniDegen Apes Sales Graph
    Updated 2022-11-26
    with cte as ( --common table expression used for creating a table with limited attributes
    select date(s.block_timestamp) as Date, s.sales_amount, m.project_name as Project, m.creator_name, m.creator_address, m.token_name
    from solana.core.dim_nft_metadata m join solana.core.fact_nft_sales s on s.mint=m.mint --Join of the two tables to get sales amount for Degen Apes
    )
    select cte.Date, cte.sales_amount, cte.Project
    from cte
    where Project like 'Degen Apes' and Date between '1/1/2021' AND '1/1/2022' --Here we filter out the project for only Degen ape within 2021
    order by Date desc
    limit 100000;