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

evmos.core.fact_transfers

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

WHERE sender LIKE 'evmos%' AND tx_succeeded = true

GROUP BY unique_receiver

ORDER BY 2 DESC;