'eligible' AS type,

13333 AS claimers,

35000000 AS ami_amount

UNION ALL

SELECT

'claimed' AS type,

COUNT(DISTINCT claimer) AS claimers,

SUM(total_amt_claimed) AS ami_amount

FROM (

-- First dataset

SELECT

event_data:"owner_address" AS claimer,

(event_data:"rewards"::FLOAT / 1e8) AS total_amt_claimed

FROM aptos.core.fact_events

WHERE payload_function = '0x9f1ffdea234d96c84cf49e80c97f6ebbba06ef6e7ec1f8abd66f47eeeea535ca::draconian::claim_nfts'

AND event_module = 'draconian'

AND event_resource = 'ClaimEvent'

UNION ALL

-- Second dataset

SELECT

event_data:"claimer" AS claimer,

(event_data:"amount"::FLOAT / 1e8) AS total_amt_claimed

FROM aptos.core.fact_events

WHERE event_address = '0xbdd24cfe3576d5e2d6b9857cbb1caba2bb4a942cd2213b4eacd2a3b40485bedf'

AND payload_function = '0xbdd24cfe3576d5e2d6b9857cbb1caba2bb4a942cd2213b4eacd2a3b40485bedf::airdrop::airdrop_claim_entry'

AND event_module = 'airdrop'

AND event_resource = 'ClaimVesting'

) AS combined_data;