MLDZMNmp.7
Updated 2022-09-27
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
case
when INNER_INSTRUCTIONS[0]:instructions[5]:parsed:info:lamports/pow(10, 9)+INNER_INSTRUCTIONS[0]:instructions[6]:parsed:info:lamports/pow(10, 9) = s.sales_amount then 'Without Royalty fee'
else 'With Royalty fee'
end as gp,
count(distinct purchaser) as buyers,
count(s.tx_id) as no_sale,
sum(sales_amount) as volume
from solana.core.fact_nft_sales s left join solana.core.fact_transactions b on s.tx_id=b.tx_id
where MARKETPLACE ilike '%yaww%' and s.BLOCK_TIMESTAMP>='2022-07-01'
group by 1
Run a query to Download Data