case event_inputs:pool

when '100' then 'Fuse-6 (fDAI-6)'

when '101' then 'Tetranode (fDAI-7)'

when '102' then 'Olympus Pool Party (fDAI-18)'

when '103' then 'WOO pool (fDAI-14)'

when '104' then 'Cartensian (fDAI-15)'

when '106' then 'PoolTogether Deposit Tokens (fDAI-11)'

when '107' then 'Tetranode (fDAI-6)'

when '108' then 'Olympus Pool Party (fDAI-18)'

when '109' then 'Fuse-6 (fDAI-6)'

end as pool_name,

sum(event_inputs:amount/1e18) as amount_usd

from ethereum.events_emitted

where contract_address = lower('0xafd2aade64e6ea690173f6de59fc09f5c9190d74')

and tx_to_label_subtype = 'pool'

and event_name = 'PoolAllocation'

and event_inputs:pool != '1' and event_inputs:pool != '3' and event_inputs:pool != '2'

and tx_succeeded = 'TRUE'

group by pool_name