select sum((utils.udf_hex_to_int(substr(data,3,66))::int)/1e18) as staked from berachain.testnet.fact_event_logs

where topics[0]='0x9e71bc8eea02a63969f509818f2dafb9254532904319f9dbda79b67bd34a5f3d'

and contract_address=lower('0xA0E4748E68b6d73234711197e96171B896B796f4')

),

bgt_claims as (

select sum((utils.udf_hex_to_int(substr(data,3,66))::int)/1e18) as bgt_claimed from berachain.testnet.fact_event_logs

where topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and ORIGIN_TO_ADDRESS=lower('0xA0E4748E68b6d73234711197e96171B896B796f4')

select * from bero_staked, bgt_claims