select FULL_DECODED_LOG['data'][0]['value'] as address, (FULL_DECODED_LOG['data'][2]['value'])/1e18 as amount from berachain.testnet.fact_decoded_event_logs

where contract_address=lower('0x414B50157a5697F14e91417C5275A7496DcF429D')

and event_name='Allocate')

group by 1),

deallocation as (select address, sum(amount) as amount from (

select FULL_DECODED_LOG['data'][0]['value'] as address, (FULL_DECODED_LOG['data'][2]['value'])/1e18 as amount from berachain.testnet.fact_decoded_event_logs

where contract_address=lower('0x414B50157a5697F14e91417C5275A7496DcF429D')

and event_name='Deallocate')

group by 1)

select a.address, a.amount-coalesce(d.amount,0) as amount from allocation a

left join deallocation d on a.address=d.address

order by amount desc