drm.name AS platform_name,

SUM(obe.olas_amount) AS total_investment

FROM

crosschain.olas.ez_olas_bonding obe

JOIN

crosschain.olas.dim_registry_metadata drm ON obe.BLOCKCHAIN = drm.BLOCKCHAIN

GROUP BY

platform_name

ORDER BY

total_investment DESC

LIMIT 10