SELECT

SUM(amount_usd) AS grand_total

FROM

avalanche.defi.ez_bridge_activity

SELECT

platform AS protocol,

(SUM(amount_usd) / grand_total) * 100 AS protocol_share

FROM

avalanche.defi.ez_bridge_activity, total_volume

GROUP BY

platform,

grand_total

ORDER BY

protocol_share DESC;