COUNT(DISTINCT from_address) AS "Number of Voters",

(CASE

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' THEN 'VELO-USDC'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' THEN 'OP-USDC'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0x79c912fef520be002c2b6e57ec4324e260f38e50' THEN 'WETH-USDC'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0xffd74ef185989bff8752c818a53a47fc45388f08' THEN 'VELO-OP'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0xd16232ad60188b68076a235c65d692090caba155' THEN 'USDC-sUSD'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0xfd7fddfc0a729ecf45fb6b12fa3b71a575e1966f' THEN 'WETH-sETH'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0x4f7ebc19844259386dbddb7b2eb759eefc6f8353' THEN 'USDC-DAI'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0x207addb05c548f262219f6bfc6e11c02d0f7fdbe' THEN 'USDC-LUSD'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0x9355292f66552ea5717b274d27eefc8254011d83' THEN 'THALES-USDC'

WHEN CONCAT('0x', SUBSTR(input_data::STRING, 291, 40)) = '0xcdd41009e74bd1ae4f7b2eecf892e4bc718b9302' THEN 'WETH-OP'

END) AS pool

from optimism.core.fact_transactions

WHERE to_address = LOWER('0x09236cfF45047DBee6B921e00704bed6D6B8Cf7e')

AND pool IS NOT NULL

GROUP BY 2

ORDER BY 1 DESC