SELECT

COUNT(TX_HASH) AS Total_Transaction_before,

SUM(decoded_log:amount / pow(10,18)) AS Total_Amount_eth_before

FROM

blast.core.ez_decoded_event_logs

WHERE

block_timestamp >= '2024-05-27' AND block_timestamp < '2024-06-26'

AND Event_name IN ('BridgedDeposit','BridgedWithdrawal')

AND tx_status = 'SUCCESS'

AND Contract_address = '0x5e023c31e1d3dcd08a1b3e8c96f6ef8aa8fcacd1'

),

after_airdrop AS (

SELECT

COUNT(TX_HASH) AS Total_Transaction_after,

SUM(decoded_log:amount / pow(10,18)) AS Total_Amount_eth_after

FROM

blast.core.ez_decoded_event_logs

WHERE

block_timestamp >= '2024-06-26' AND block_timestamp <= '2024-07-26'

AND Event_name IN ('BridgedDeposit','BridgedWithdrawal')

AND tx_status = 'SUCCESS'

AND Contract_address = '0x5e023c31e1d3dcd08a1b3e8c96f6ef8aa8fcacd1'

after_airdrop.Total_Transaction_after AS Total_transaction_after,

before_airdrop.Total_Transaction_before AS Total_transaction_before,

((after_airdrop.Total_Transaction_after - before_airdrop.Total_Transaction_before) / before_airdrop.Total_Transaction_before) * 100 AS Percentage_change_total_transaction,

after_airdrop.Total_Amount_eth_after AS Total_Amount_eth_after,

before_airdrop.Total_Amount_eth_before AS Total_Amount_eth_before,

((after_airdrop.Total_Amount_eth_after - before_airdrop.Total_Amount_eth_before) / before_airdrop.Total_Amount_eth_before) * 100 AS Percentage_change_Total_Amount_eth

FROM

before_airdrop, after_airdrop;