gayatridodmaniQuery5
Updated 2022-11-27
9
1
2
3
4
5
6
7
8
9
›
⌄
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