sinahosseinzadehUntitled Query
    Updated 2022-10-30
    with Hyperspace_datas as (select sales_amount,block_timestamp,purchaser,seller,sales.mint,contract_name from solana.core.fact_nft_sales as sales
    inner join solana.core.dim_nft_metadata as meta
    on meta.mint=sales.mint
    where program_id in ('HYPERfwdTjyJ2SCaKHmpF2MtrXqWxrsotYDsTrshHWq8') and succeeded=1)
    , Coral_Cube_datas as (select sales_amount,block_timestamp,purchaser,seller,sales.mint,contract_name from solana.core.fact_nft_sales as sales
    inner join solana.core.dim_nft_metadata as meta
    on meta.mint=sales.mint
    where program_id in ('6U2LkBQ6Bqd1VFt7H76343vpSwS5Tb1rNyXSNnjkf9VL','hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk') and succeeded=1)

    select sum(sales_amount) as val , 'hyperspace' as l from Hyperspace_datas
    UNION
    select sum(sales_amount) as val , 'coral cube' as l from Coral_Cube_datas
    Run a query to Download Data