Arashhgas used when token in and token out is not osmo group by token out
    Updated 2022-06-24
    WITH T1 AS(
    select AVG(GAS_USED) AS XXX,to_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 to_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.to_CURRENCY=B.ADDRESS
    order by "Average of gas used" desc
    Run a query to Download Data