select

'Polygon Bridge' as Bridge,

sum (ETH_VALUE) as "Total ETH deposited",

count (distinct FROM_ADDRESS) as "Unique Wallets",

count (t.tx_hash)as "Total transaction", count (tx_hash)/(count (distinct FROM_ADDRESS)) as "frequency of use",

sum (ETH_VALUE)/count (distinct FROM_ADDRESS) as "Average ETH deposited"

from ethereum.core.fact_transactions t

where (to_address =lower ('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC') or to_address=lower ('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1'))

and ETH_value>10

union

select

'Hop Bridge' as Bridge,

sum (ETH_VALUE) as "Total ETH deposited",

count (distinct FROM_ADDRESS) as "Unique Wallets",

count(e.tx_hash)as "Total transaction",count(e.tx_hash)/(count (distinct FROM_ADDRESS)) as "frequency of use",

sum (ETH_VALUE)/count (distinct FROM_ADDRESS) as "Average ETH deposited"

from ethereum.core.fact_event_logs E

right join ethereum.core.fact_transactions T on T.TX_HASH=E.TX_HASH

where CONTRACT_ADDRESS =lower ('0xb8901acB165ed027E32754E0FFe830802919727f')

and EVENT_NAME= 'TransferSentToL2'

and event_inputs:chainId='137'

and ETH_value>10