CASE SUBSTRING(receiver_clean, 1, 5)

WHEN 'evmos' THEN 'Evmos'

WHEN 'osmo1' THEN 'Osmosis'

when 'strid' THEN 'Stride'

WHEN 'cosmo' THEN 'Cosmos'

WHEN 'axela' THEN 'Axelar'

WHEN 'juno1' THEN 'Juno'

ELSE SUBSTRING(receiver, 1, 5)

END AS unique_receiver,

COUNT(*) AS count

FROM (SELECT

*,

CASE

WHEN receiver NOT LIKE '{"%' THEN receiver

ELSE parse_json(receiver):autopilot:receiver

END AS receiver_clean

FROM

evmos.core.fact_transfers

WHERE

receiver NOT LIKE '{"%' OR LEFT(receiver::string, 2) = '{"' )

AS subquery

WHERE receiver LIKE 'evmos%' AND tx_succeeded = true

GROUP BY unique_receiver;