strawbettytotal amount of donation
    Updated 2022-03-18
    with donations as (
    SELECT
    tx_id,
    block_timestamp::date as date,
    receiver as GILBERT_THE_GOANNA_ADDRESS,
    amount as donation_volume
    FROM algorand.payment_transaction
    where receiver = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
    order by date
    )

    select sum(donation_volume) as total_donation from donations
    Run a query to Download Data