select AVG(GAS_USED) AS XXX,FROM_CURRENCY FROM

osmosis.core.fact_swaps a inner join osmosis.core.fact_transactions b on a.TX_ID=b.TX_ID

where

FROM_CURRENCY !='uosmo'

AND TO_CURRENCY !='uosmo'

GROUP BY FROM_CURRENCY

ORDER BY XXX DESC)

SELECT LABEL, XXX AS "Average of gas used" FROM T1 A INNER JOIN osmosis.core.dim_labels B ON A.FROM_CURRENCY=B.ADDRESS

order by "Average of gas used" desc