barbodUntitled Query
    Updated 2022-05-26
    with tb1 as (select
    *
    from algorand.application_call_transaction
    where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery'
    )

    select
    distinct SENDER as purchasers,
    count(tx_group_id) as count_sale,
    sum(AMOUNT) as daily_algo

    from algorand.payment_transaction
    where tx_group_id in (select tx_group_id from tb1)
    group by 1 order by 2 desc limit 20
    Run a query to Download Data