zakkisyedTotal Donation Amount by Purchaser
    Updated 2024-04-03

    -- forked from Total Encashed Amount by Party @ https://flipsidecrypto.xyz/edit/queries/be756557-ac25-47e2-8ee1-528a42723d49

    WITH res1 AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    {'Content-Type': 'application/json'},
    {
    'sheets_id': '1YfgsP2UGAkeq3GOFVNvjOkI0o3sSog37LpXlX7hZWa0',
    'tab_name': 'Sheet4'
    }
    ) AS result
    FROM DUAL
    ),

    res2 AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    {'Content-Type': 'application/json'},
    {
    'sheets_id': '1YfgsP2UGAkeq3GOFVNvjOkI0o3sSog37LpXlX7hZWa0',
    'tab_name': 'Sheet5'
    }
    ) AS result
    FROM DUAL
    ),
    data AS (
    SELECT result:data AS json_result_must_pivot FROM res1
    UNION ALL
    SELECT result:data AS json_result_must_pivot FROM res2
    )
    ,
    QueryRunArchived: QueryRun has been archived