gayatridodmaniQuery1: Highest Amount
Updated 2022-11-26
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with cte as ( --common table expression used for creating a table with limited attributes
select s.mint, s.purchaser, s.sales_amount, m.project_name
from solana.core.dim_nft_metadata as m inner join solana.core.fact_nft_sales as s on m.mint=s.mint --inner join of metadata table with sales table in solana core
where s.sales_amount is not null --we only need rows with sales amount listed for accurate results
)
select cte.project_name, sum(sales_amount) as total_sales_amount --only required attributes are called
from cte --we will use cte table as a reference table
group by cte.project_name
order by total_sales_amount DESC
limit 10;
Run a query to Download Data