WITH airdrop_claim AS

SELECT tx:tx_result:log[0]:events[2]:attributes[4]:value::integer /pow(10,6) AS amount,

div0(tx:tx_result:log[0]:events[2]:attributes[4]:value::integer /pow(10,6) , 336) AS nft_count

FROM terra.core.fact_transactions

WHERE tx_succeeded = true

AND TX:tx_result:log[0]:events[2]:attributes[1]:value::string = 'claim'

AND TX:tx_result:log[0]:events[2]:attributes[0]:value::string = 'terra12uz7uqdz4fs9fzj8mk82ajhj2tr3qu682fc4at30cvgypmch7wpqlnk74e')

SELECT Count(*),

Sum(amount) as amount_claimed,

Sum(nft_count) as count_nfts_claimed_airdrop,

Sum(nft_count) / 2968 * 100 as percentage_nfts_claimed_airdrop,

Sum(amount) / (2*pow(10,6)) * 100 as percantage_amount_claimed,

Sum(amount) / (997248) * 100 as amount_claimed_against_ronin_airdrop

FROM airdrop_claim