Platform,

direction,

SUM(amount) AS total_transaction_volume_in_sol

FROM

SOLANA.defi.fact_bridge_activity

WHERE

EXTRACT(MONTH FROM block_timestamp) = 8

AND

MINT ='So11111111111111111111111111111111111111112'

GROUP BY

Platform,

direction

ORDER BY

total_transaction_volume_in_sol DESC;