zakkisyedDifferent Bond Types Purchased
Updated 2024-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from All Donors' Donations to different parties @ https://flipsidecrypto.xyz/edit/queries/e880fb62-cbd8-49a9-b8cf-c51dcd4434d6
-- forked from Top Donors' Donations to different parties @ https://flipsidecrypto.xyz/edit/queries/1c238510-02cf-4b8d-bcde-86bac9e7ad9b
-- forked from Total Donation Amount by Purchaser @ https://flipsidecrypto.xyz/edit/queries/9a1943e9-d326-4554-9562-f1c513db907f
-- 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 (
QueryRunArchived: QueryRun has been archived