drm.name AS expense_category,

SUM(obe.olas_amount) AS total_expense

FROM

crosschain.olas.ez_olas_bonding obe

JOIN

crosschain.olas.dim_registry_metadata drm ON obe.product_id = drm.registry_id

GROUP BY

expense_category

ORDER BY

total_expense DESC