COUNT(*) AS total_swaps

FROM thorchain.defi.fact_swaps

WHERE FROM_ASSET like '%DOGE%' OR

TO_ASSET like '%DOGE%';