MLDZMNmp.8
    Updated 2022-09-27
    select
    case
    when
    INNER_INSTRUCTIONS[1]:instructions[0]:parsed:info:lamports/pow(10, 9)
    +INNER_INSTRUCTIONS[1]:instructions[1]:parsed:info:lamports/pow(10, 9)
    +INNER_INSTRUCTIONS[1]:instructions[2]:parsed:info:lamports/pow(10, 9) = s.sales_amount then 'With Royalty fee'
    else 'Without 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 '%solanart%' and s.BLOCK_TIMESTAMP>='2022-07-01'
    group by 1
    Run a query to Download Data