SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/0eaf3794-1289-4db3-add4-63ec057abadd/data/latest'):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/1a95886c-a81f-4f81-af1a-db87748f84a5/data/latest'):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/5cdab092-ccee-451a-94f9-8d35a3305996/data/latest'):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/b6348f71-332f-4aad-8e1a-3f3a114173ea/data/latest'):"data" AS data

), all_data as (

SELECT

FLATTENED.VALUE:PROJECT_NAME as PROJECT_NAME,

FLATTENED.VALUE:SCORE AS transactions,

FLATTENED.VALUE:TIP_AMOUNT AS TIP_AMOUNT

FROM

live_data,

LATERAL FLATTEN(INPUT => live_data.data) AS FLATTENED

), tab1 as (

select

count(*) as total_tip_events,

sum(amount) as total_tip_volume

from solana.core.fact_transfers

where tx_to in (

'96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5',

'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe',

'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY',

'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49',

'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh',