with t1 as ( select concat('0x',SUBSTRING(input_data,291,40)) as pools, count(DISTINCT tx_hash) as total_vote

from optimism.core.fact_transactions

where origin_function_signature = '0x7ac09bf7' and to_address = '0x09236cff45047dbee6b921e00704bed6d6b8cf7e'

group by 1

order by 2 desc

limit 5),

t2 as ( select pools , total_vote from t1)

select pools , case when pools = lower('0x79c912FEF520be002c2B6e57EC4324e260f38E50') then 'WETH-USDC'

when pools = lower('0xFFD74EF185989BFF8752c818A53a47FC45388F08') then 'VELO-OP'

when pools = lower('0x47029bc8f5CBe3b464004E87eF9c9419a48018cd') then 'OP-USDC'

when pools = lower('0xd16232ad60188B68076a235c65d692090caba155') then 'USDC-sUSD'

when pools = lower('0xe8537b6FF1039CB9eD0B71713f697DDbaDBb717d') then 'VELO-USDC' end as pools

, total_vote

from t2