Updated 2022-11-27
    with cte AS( --common table expression used for creating a table with limited attributes
    select m.blockchain, m.token_name, m.project_name, m.creator_name, s.sales_amount
    from solana.core.dim_nft_metadata as m left join solana.core.fact_nft_sales as s on m.token_id=s.tx_id
    )

    select cte.blockchain, count(cte.token_name) as total_token, count(cte.project_name) as total_projects --Total Token gives us the count of tokens within Solana
    from cte
    group by 1 --Group by is applied on Blockchains
    order by 2,3 --Ordered by Total Token
    Run a query to Download Data