SELECT
CASE SUBSTRING(sender, 1, 4)
WHEN 'osmo' THEN 'Osmosis'
WHEN 'cosm' THEN 'Cosmos'
ELSE SUBSTRING(sender, 1, 4)
END AS unique_sender,
COUNT(*) AS count
FROM
(SELECT *
FROM cosmos.core.fact_transfers
WHERE receiver LIKE 'evmos%' AND tx_succeeded = true) AS subquery
GROUP BY unique_sender;